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
vikasg2006
Messages: 78
Registered: March 2006
Location: Dubai
Member
hy,
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.

Vikas
Re: Which one is pre compiled? [message #200940 is a reply to message #200928] Thu, 02 November 2006 00:34 Go to previous message
rleishman
Messages: 3724
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: printf-line add-on
Next Topic: Using Distinct and Upper in Select statement
Goto Forum:
  


Current Time: Tue Dec 06 06:35:24 CST 2016

Total time taken to generate the page: 0.13441 seconds