Oracle if inserting or updating then

' When Inserting'); ELSIF UPDATING THEN dbms_output.put_line(v Msg

The compound trigger body does not have an initialization block and thus no exception block.By placing a SELECT statement within the INSERT statement, you can perform multiples inserts quickly.With this type of insert, you may wish to check for the number of rows being inserted.Since the subprogram code is in the main code (INLINE), the overhead of calling that subprogram is saved.This allows you to program using a modular method, producing readable, maintainable source code, while the compiler optimizes the code to make it more efficient.With the 11g database, Oracle has included this feature in PL/SQL.Basically subprogram inlining is where the program calls a subprogram (procedure or function) and the compiler places the actual subprogram code in place of the call to that code.The references to : OLD, : NEW or : PARENT cannot be used in the declaration section, BEFORE STATEMENT or AFTER STATEMENT.Only the BEFORE EACH ROW section can change the : NEW value.Those of you who frequent the asktom.Web site know that I have an aversion to triggers.Once upon a time, a long time ago, I thought triggers were the coolest thing ever and I used (and abused) them heavily.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “oracle if inserting or updating then”

  1. , available from the most important cities of Pakistan, India and Bangladesh, our team and girls are focussed in bring telephone pleasure to all our clients: Aunties, Bhabhis and Desi Girls are available to chat with you, all our numbers have access from mobile.