In packages the source code is compiled into p code ? how
do we describe the p code
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinu
Yes u r correct Swapna,But if we want 2 get the source code
of stored procedure,function,trigger or package ten the
query is......
SELECT text
FROM USER_SOURCE
WHERE NAME='PROCEDURE_NAME/FUNCTION_NAME/TRIGGER_NAME';
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / arup ratan banerjee
But Swapna,,,,
Those codes get stored in ALL_SOURCE tables...
Just check this query out...
Select * from ALL_SOURCE where owner='<OWNER_NAME>'
and type='PROCEDURE'
u WILL GET THE SOURCE CODE FROM HERE
Is This Answer Correct ? | 0 Yes | 2 No |
Mention what are the benefits of pl/sql packages?
What are views in sql?
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
How many sql statements are used? Define them.
What is crud sql?
What programs use sql?
What is Highwatermark?
how to drop an existing index in mysql? : Sql dba
I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body
What is memory optimized?
Can function return multiple values in sql?
What is sql*loader and what is it used for?