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

Which table is left in left join?

951

---

what is top in tsql? : Transact sql

1021

---

Why join is faster than subquery?

1039

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1536

---

What are aggregate functions in sql?

1086

---

Explain architecture of sql server notification services?

981

---

When you have to use a default "rollback to" savepoint of plvlog?

1123

---

what is sub-query? : Transact sql

1038

---

Why triggers are used?

936

---

what are the advantages a stored procedure? : Sql dba

922

---

What are the qualities of 2nf?

973

---

What are the different sql languages?

983

---

How do I view a table in sql?

941

---

Mention what plvcmt and plvrb does in pl/sql?

1061

---

What does the base_object_type column shows in the user.triggers data dictionary view?

992

---