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

Which are the different character-manipulation functions in sql?

0 Answers  

---

How long it takes to learn pl sql?

0 Answers  

---

How does a self join work?

0 Answers  

---

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

What is the purpose of the primary key?

0 Answers  

---

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

What are all the ddl commands?

0 Answers  

---

What does inner join mean?

0 Answers  

---

Is nosql faster than sql?

0 Answers  

---

how to check server status with 'mysqladmin'? : Sql dba

0 Answers  

---