Home > tips > PLSQL Notes From 3 day course in Turkcell Academy

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

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: