Interested to Buy Any Domain ? << Click Here >> for more details...
In packages the source code is compiled into p code ? how
do we describe the p code
- 3 Answers
- 6957 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 are sql triggers used for?
How do you delete duplicates in sql query using rowid?
Does sql between include endpoints?
Can you load data into multiple tables at once? : aql loader
Why commit is not used in triggers?
How would you convert date into julian date format?
What is a unique key and primary key and foreign key?
How do I add a database to sql?
What are the types of subqueries?
Can variables be used in sql statements?
what is clause? : Sql dba
What is cursor status?
How can we find duplicate records in a table?
What is the syntax to add a record to a table?
Why do we use subquery?
