In packages the source code is compiled into p code ? how
do we describe the p code
- 3 Answers
- 6363 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
After compiling procedures,functions and triggers(in new
versions only),Those will be stored in the form of p-code
(after parsing) in SGA(System Global Area).
The advantage of p-code is Since it was there in SGA which
can be shared by all,Whenever you execute procedure or
function,It won't be recompiled.It uses already compiled p-
code.So,time can be saved.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the sql*loader and import utilities? : aql loader
How to add a column ‘salary’ to a table employee_details?
How to Execute a Package in PL/SQL.?
What is the difference between delete, truncate and drop command?
What is the difference between truncate and drop statements?
Which is better cte or subquery?
What are records give examples?
Is grant a ddl statement?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is sql dialect?
What is bitemporal narrowing?
What are field types?
What is data type in database?
Is foreign key mandatory?
How do I create an index in word?
