How to Unlock User / Change Oracle PasswordRumesh Aponso (RMAX)Nov 8, 20241 min readUpdated: Nov 13, 2024ALTER USER DUMMYUSER ACCOUNT UNLOCK;ALTER USER DUMMYUSER IDENTIFIED BY PASSWORD;
CONNECT BY PRIOR / Hierarchical Queries / Query Tree StructureExample 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...
Encode Decode base64 in PLSQLDecode base64 in PLSQL: DECLARE CURSOR get_base64_clob IS SELECT neutral_file FROM c_smart_document_tab WHERE sequence_no = '42'; ...
Comments