PLSQL Notes From 3 day course in Turkcell Academy

Last week, I had a chance to be author of PLSQL course in Turkcell Academy.

Following issues worth noting which were a product of focused working/reading, nearly for a month, on PL/SQL topic:

-If you handle the exception fired by error RAISE_APPLICATION_ERROR in a BEFORE INSERT trigger body, it is surprising that the record is inserted despite the error message which is shown by RAISE_APPLICATION_ERROR.

- It is also strange that, if you want to prevent truncate table statements with a trigger. Although it is not executed, it will issue COMMIT implicitly because truncate statement is DDL.

http://hemantoracledba.blogspot.com/2011/06/ddl-triggers.html

 

- In order to get use of 11G fine grained dependency feature, thus not to invalidate procedures, views when exactly not needed, in sql statements you must reference underlying table columns with fully qualified names.

http://htmldb.oracle.com/pls/otn/f?p=2853:4:830114251864401::NO::P4_QA_ID:15642