U CAN REFER ALL_SOURCE TABLE... SELECT * FROM ALL

How to maintain the history of code changes of pl/sql?

Question Posted / arup ratan banerjee

Answer Posted / arup ratan banerjee

U CAN REFER ALL_SOURCE TABLE...
SELECT * FROM ALL_SOURCE WHERE OWNER='IHIS11'
AND TYPE = 'PROCEDURE';

U will get procedure body from this table

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between joins?

1037

who introduced sql?

1012

Why is pl sql needed?

927

When is the explicit cursor used ?

1030

what are the different type of normalization? : Sql dba

1025

What is nosql example?

1029

What is full join in sql?

987

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2216

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

985

What is trigger types in sql?

989

What is pivot query?

1066

What is schema in sql example?

1172

Can a commit statement be executed as part of a trigger?

1048

What is the difference between the sql*loader and import utilities? : aql loader

1037

What is data control language (dcl)?

1132