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 is trigger point?

976

---

What are sql data types?

998

---

explain advantages of myisam over innodb? : Sql dba

1053

---

Write the alter statement to enable all the triggers on the t.students table.

1109

---

What is sql not null constraint?

1005

---

Does sql use python?

1013

---

how to extract a unit value from a date and time? : Sql dba

978

---

What is an escape character in sql?

1008

---

What is the starting oracle error number? What is meant by forward declaration in functions?

971

---

Do stored procedures prevent sql injection?

953

---

What are aggregate functions in sql?

1136

---

What are the types of optimization?

927

---

Should I use mbr or gpt?

1009

---

How do you delete data from a table?

1009

---

What is foreign key sql?

973

---