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 purpose of the partition table?

1034

What is the difference between an inner and outer join?

998

Why procedure is used in sql?

1025

how to enter numeric values as hex numbers? : Sql dba

1046

What do you understand by pl/sql records?

1003

How to check if a column is nullable before setting to nullable?

1103

What is substitution variable?

1031

What is an ndf file?

974

How do I run a script in sql developer?

935

What is triggering circuit?

1050

how to drop an existing index in mysql? : Sql dba

1053

What is partition by in sql?

1049

How many types of primary keys are there?

1019

What does t sql mean?

927

How to run sql statements with oracle sql developer?

1048