Answer Posted / guru

--

CREATE TABLE SOURCE_HIST -- Create
history table
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
DECLARE
BEGIN
if DICTIONARY_OBJ_TYPE in ('PROCEDURE', 'FUNCTION',
'PACKAGE', 'PACKAGE BODY', 'TYPE')
then
-- 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;
end if;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20000, SQLERRM);
END;
/
show errors
--

what are the different tables present in mysql? : Sql dba

923

---

Can we call a function containing dml statements in a select query?

917

---

Does a join table need a primary key?

901

---

How is pl sql different from sql?

1010

---

What is an index in sql with example?

918

---

What is trigger explain it?

959

---

How do I find duplicates in two columns?

1057

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1058

---

explain the advantages and disadvantages of stored procedure? : Sql dba

956

---

Can a composite key be null?

909

---

What is hibernate and its relation to sql?

1065

---

Why do we use subquery?

942

---

What are the types of index in sql?

1014

---

How to select 10 records from a table?

1096

---

What is scope and visibility in PL/SQL?

1113

---