header ads
Showing posts with the label PLSQLShow all
DBMS_LOCK.SLEEP PLSQL

DBMS_LOCK.SLEEP

OracleAppsPractice 11:47 PM

DBMS_LOCK.SLEEP "DBMS_LOCK.SLEEP" will be used if we want to create artificial slow down process between one function/procedure. In below function we are providing "60" se…

PLSQL PLSQL

PLSQL

OracleAppsPractice 8:43 AM

PLSQL 1. PLSQL Trigger CREATE OR REPLACE TRIGGER XX_TEST_TRIGGER AFTER   INSERT OR   UPDATE OR   DELETE ON XX_TEST_TABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE l_transaction V…