Oracle if updating then

=0 THEN ret:=FALSE; ELSIF start_stop NOT IN ('START','STOP') THEN ret:=FALSE; ELSIF start_stop = 'START' THEN ret_code:=DBMS_PROFILER.

oracle if updating then-51oracle if updating then-53

An example would be the IF exit, usually programmers will place the various nested IF constructs that actually perform code operations first, even if they are rarely exercised, by placing the exit IF first the processing associated with the other IF processing is avoided.

This is especially true of IF constructs contained within LOOP structures.

Here is the suituation: If I insert data into table1, same data will be inserted into table2.

If I update data in table1, row with same primary key in table2 is also updated. Thanks Here is an example of world popular table 'EMP', I make another table 'EMP_TEMP' identical to EMP and now i want to update, insert and delete record from EMP_TEMP whenever an update, insert, and delete occured in emp.

If you need to determine if the value is changing, you'll still need to code comparison logic for :old and :new values.

When row is inserted/updated/deleted in table1, the same action is also applied for table2.

=0 THEN ret:=FALSE; END IF; ELSIF start_stop AND ret_code=0 THEN ret_code:=DBMS_PROFILER.

It works, but it won't tell you if the value changed, only that the column is being updated (even if the update doesn't change the value).

Using the PROFILER_CONTROL procedure as an example look at Figure 1.

Tags: , ,