| Ruby on Rails instal… on How to install Ruby On Rails r… | |
 | john rich on DotA Heroes Pool |
 | Michael on hackertest.net level 1 –… |
 | membrane on hackertest.net level 1 –… |
 | shravan on Toad for Oracle keep prompting… |
 | Equinoxio2k on hackertest.net level 1 –… |
 | MH Moni on VB6 on Vista, Error accessing … |
 | ENoiD on DotA Heroes Pool |
 | yash on Generate Insert Statement Scri… |
 | zvit on Toad for Oracle keep prompting… |
Today my first time using Oracle Fine-Grained Auditing. Why do I need to use Oracle Fine-Grained Auditing? This is because there is a table that is accessed by many procedures, triggers and packages. So that in case of deletion, I can not track from which the “DELETE” order came from. I’ve tried using a trigger [...]
Filed under: Oracle | Tagged: Oracle Procedure, Oracle SQL, oracle table, Oracle Trigger | Leave a Comment »
Hi, I want to cancel the trigger of a table that does not work if the logic condition is not met. So as if I want the trigger to rollback (for example = cancel delete in before-delete trigger). At first, the trigger like this : CREATE OR REPLACE TRIGGER MIS.TRIG01_TABLE_A BEFORE DELETE ON PANDAZEN.TABLE_A REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN INSERT INTO PANDAZEN.TABLE_B SELECT [...]
Filed under: Oracle | Tagged: Oracle, Oracle SQL, oracle table, Oracle Trigger | Leave a Comment »
 |
 |
|
pandazen
