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

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

---

What is tuple in sql?

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

Which one is faster ienumerable or iqueryable?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

What are the dml statements?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---

What is delimiter in pl sql?

0 Answers  

---

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---