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 an ndf file?

1062

What is difference between sql and excel?

1176

What are the two different parts of the pl/sql packages?

1139

How exception is different from error?

1065

how to install mysql? : Sql dba

1157

what is the command line end user interface - mysql? : Sql dba

1028

what is the difference between sql and t-sql? : Transact sql

1136

what is the different between now() and current_date()? : Sql dba

1072

What is sqlcontext?

1145

What is use of package in pl sql?

1068

What is a parameter query?

1141

What is sql rowcount?

1070

What is aggregate function in sql?

1080

Does group by remove duplicates?

1092

What are the two parts of design view?

1062