SQL Tips & Quirks

1. PL/SQL Anonymous block sample with DBMS_APPLICATION_INFO.set_module example & PL/SQL procedure invocation
Note: Enable DBMS Output in SQL Developer

DECLARE
V_MODULE VARCHAR2 (64) := 'ABCD';
V_ACTION VARCHAR2 (64) := 'DO NOT ABCD';
begin
DBMS_APPLICATION_INFO.set_module (V_MODULE, V_ACTION);
dbms_application_info.READ_MODULE(V_MODULE,V_ACTION);
DBMS_OUTPUT.PUT_LINE('Module IS '||V_MODULE||' Action IS '||V_ACTION);
END;
/
2. Next
3.