How to run .sql file in SQLPLUS

Rumesh Aponso (RMAX)

Nov 22, 20241 min read

sqlplus <<service_name>>/<<password>>@<<database_name>> @<<filename>>.sql

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