In packages the source code is compiled into p code ? how
do we describe the p code

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does sql*loader handles newline characters in a record? : aql loader

765


What is a common use of group by in sql?

790


How many aggregate functions are available there in sql?

701


Why do we use partitions in sql?

722


How to connect a sql*plus session to an oracle server?

819






Explain lock escalation? : Transact sql

867


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

814


What if we write return in procedure?

974


What is string data type in sql?

726


What is db journal file?

685


What is an exception in PL/SQL? What are the two types of exceptions?

851


What does the hierarchical profiler does?

755


Can we use commit inside a trigger?

763


What is a database event trigger?

799


Why do we use joins in sql?

693