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
- 7164 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 usage of the distinct keyword?
What is a trigger word?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Can a table contain multiple primary key’s?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What are triggers and its types?
Can we group by two columns in sql?
What is the most restrictive isolation level? : Transact sql
What are the types of dbms?
How do I clear the screen in sql plus?
What are different types of functions in sql?
How much does sql certification cost?
What are the benefits of triggers?
Which constraints we can use while creating database in sql?
Write a sql select query that only returns each name only once from a table?
