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

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1142

What is PL/SQL Records?

1197

what is the difference between a web-garden and a web-farm? : Sql dba

1081

Do we need to rebuild index after truncate?

1036

What is embedded sql with example?

1056

What is sql*loader and what is it used for? : aql loader

1176

What are the sql commands?

1185

how can we know the count/number of elements of an array? : Sql dba

1064

How do I order by ascending in sql?

1026

Where can I learn sql for free?

993

What does count (*) do in sql?

1017

What is indexing in sql and its types?

1081

What is a primary key sql?

1046

What is sql data?

998

What will you get by the cursor attribute sql%found?

966