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.

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';

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

How do you run a query?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

what are local and global variables and their differences? : Sql dba

0 Answers  

---

Does indexing improve query performance?

1 Answers  

---

How to use transactions efficiently : transact sql

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

What is the difference between syntax error and runtime error?

0 Answers  

---

Are subqueries better than joins?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

Is primary key always clustered index?

0 Answers  

---