How to get oracle service name?

Rumesh Aponso (RMAX)

Dec 9, 20221 min read

Updated: Nov 13, 2024

SELECT * FROM v$instance;

SELECT host_name FROM v$instance;
SELECT instance_name FROM v$instance;

Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...

Decode base64 in PLSQL: DECLARE CURSOR get_base64_clob IS SELECT neutral_file FROM c_smart_document_tab WHERE sequence_no = '42'; ...

Related Posts