Question: I have a question on choosing the
compilation method in oracle. I \have a choice between compiling
and interpreted PL/SQL but I want to know the advantages of
compiling vs. interpreted PL/SQL.
What is the difference between compiled and interpreted PL/SQL?
Answer: The main differences between
compiling and interpreting is that compiling forces all
pre-processing at once, while interpreted PL/SQL is done
- Interpreted: The code is parsed and changed to source code, one
line at a time. Only one error at a time appears. Interpreted is
flexible than compiled code and allows for more dynamic features
such as late binding.
Also, compiling PL/SQL hides the source code (good for vendor
code obfuscation), makes and compiling the code run faster, but is
less flexible (as is no late binding).
this article for details on the differences between compiling
and interpreted PL/SQL.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.