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

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

what is the difference between inner and outer join? Explain with example. : Sql dba

549


What are sql procedures?

584


Is not null in sql?

560


what are the types of join and explain each? : Sql dba

534


What is the difference between an inner join and an outer join?

516






What are different types of indexes?

512


What is over () in sql?

529


Is join same as left join?

533


Does a user_objects view have an entry for a trigger?

570


What are the most important ddl statements in sql?

577


How can we make an if statement within a select statement?

543


How we can update the view?

603


What is dynamic query?

542


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

505


What is the left table in sql?

519