How to maintain the history of code changes of pl/sql?
Answers were Sorted based on User's Feedback
Answer / 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 ?||4 Yes||0 No|
Answer / guru
CREATE TABLE SOURCE_HIST -- Create
AS SELECT SYSDATE CHANGE_DATE, USER_SOURCE.*
FROM USER_SOURCE WHERE 1=2;
CREATE OR REPLACE TRIGGER change_hist --
Store code in hist table
AFTER CREATE ON SCOTT.SCHEMA --
Change SCOTT to your schema name
if DICTIONARY_OBJ_TYPE in ('PROCEDURE', 'FUNCTION',
'PACKAGE', 'PACKAGE BODY', 'TYPE')
-- Store old code in SOURCE_HIST table
INSERT INTO SOURCE_HIST
SELECT sysdate, user_source.* FROM USER_SOURCE
WHERE TYPE = DICTIONARY_OBJ_TYPE
AND NAME = DICTIONARY_OBJ_NAME;
WHEN OTHERS THEN
|Is This Answer Correct ?||5 Yes||2 No|
What is offset in sql query?
What are the types of queries in sql?
What is the difference between left and left outer join?
explain primary keys and auto increment fields in mysql : sql dba
Explain dml and ddl?
What is a trigger word?
Can a key be both primary and foreign?
What is pivot query?
How to perform a loop through all tables in pl/sql?
What does over partition by mean in sql?
how can i read write files from pl/sql
What are the different set operators available in sql?