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 update f as m and m as f from the below table testtable?

0 Answers  

---

What is the difference between joins?

0 Answers  

---

What are the basic techniques of indexing?

0 Answers  

---

what is a trigger in mysql? : Sql dba

0 Answers  

---

Which one is better sql or oracle?

0 Answers  

---

Explain what is sql?

0 Answers  

---

Does truncate table reset auto increment?

0 Answers  

---

Does a user_objects view have an entry for a trigger?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

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 port does sql server use?

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---