Home » SQL & PL/SQL » SQL & PL/SQL » Which one is pre compiled?
Which one is pre compiled? [message #200928] Wed, 01 November 2006 23:28 Go to next message
Messages: 78
Registered: March 2006
Location: Dubai
I have one confusion . Out of Procedure, function and packages which is not compiled every time whenever they are calling means stored in compiled form in database.

Re: Which one is pre compiled? [message #200940 is a reply to message #200928] Thu, 02 November 2006 00:34 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
All are stored in compiled form in the database.

In v7, Triggers were not stored in compiled format, forcing a parse at runtime. This was fixed in v8.

Ross Leishman
Previous Topic: would like to double check .....
Next Topic: Using Distinct and Upper in Select statement
Goto Forum:

Current Time: Tue Aug 22 19:48:00 CDT 2017

Total time taken to generate the page: 0.01799 seconds