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 |
Define the select into statement.
I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?
Does sql view stored data?
What are different types of sql?
what is the difference between undefined value and null value? : Sql dba
discuss about myisam key cache. : Sql dba
What is left join in sql?
which tcp/ip port does sql server run on? : Sql dba
What does select top 1 do in sql?
Why triggers are used?
What is data profiling in sql?
Why truncate is used in sql?