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 |
How to place comments in pl/sql?
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
Is grant a ddl statement?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
What is PL/SQL Records?
What are the disadvantages of not performing database normalization?
How does sql*loader handles newline characters in a record? : aql loader
Why truncate is faster than delete?
What is trigger explain with example?
Why does sql need a server?
When would you denormalize?
8 Answers MBT, Microsoft, MMU,