PL/SQL (MOSC)

MOSC Banner

Need Help on understanding PL SQL and Database Trigger

edited Jul 13, 2015 10:01AM in PL/SQL (MOSC) 3 commentsAnswered

TRIGGER

1.) does it use pl sql language?

2.) old.COLUMN_NAME. is old a syntax? is that the original value? im assuming that to get the user updated value we will just use the COLUMN_NAME?

3. can anyone explain the statement below? what does the quotation mark do?

CREATE OR REPLACE TRIGGER SIEBEL.S_TEMP_ORG_EXT
AFTER UPDATE OF "PASSWORD", PR_ADDR_ID, PR_CON_ID, CUST_STAT_CD OR DELETE
   ON SIEBEL.S_ORG_EXT   

FOR EACH ROW

4.) what does colum do? :master_ou_id

5.)what does updating do? UPDATING('COLUMN_NAME') what does UPDATING without the () do?

6.) what does WHEN OTHERS THEN do?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center