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
- 7100 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
how to drop an existing view in mysql? : Sql dba
what is a record in a database ? : Sql dba
How do you declare a user-defined exception?
what are the performance and scalability characteristics of mysql? : Sql dba
What are the different ddl commands in sql?
How do I partition in sql?
Why we use pl sql?
How to write pl sql program in mysql command prompt?
Why is sql better than hql?
What is an example of translating a date into julian format?
Write a sql query to get the third highest salary of an employee from employee_table?
How do I find duplicates in the same column?
What is 19 null in sql?
What is pessimistic concurrency control? : Transact sql
What is a unique constraint?
