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

3 Answers
14975 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

954

What is cte sql?

924

What is input buffer in sql*plus?

1121

what is recursive stored procedure? : Sql dba

929

What is query syntax?

912

how to check myisam tables for errors? : Sql dba

1256

What is a ddl command?

1003

What is java sql drivermanager?

1018

Is foreign key mandatory?

938

Can instead of triggers be used to fire once for each statement on a view?

894

how can we submit a form without a submit button? : Sql dba

916

What is the difference between null value, zero, and blank space?

1134

How to start oracle sql developer?

983

What is attribute indicator in pl sql?

958

What is package in pl sql with an examples?

967