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
--

Write an sql query to select all records from the table?

1026

---

What is varchar sql?

1132

---

What is delimiter in pl sql?

1061

---

Why is sql*loader direct path so fast?

1100

---

Explain spool.

1176

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1425

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

966

---

What are pl/sql packages?

1101

---

How many joins can you have in sql?

934

---

What is mutating sql table?

1106

---

How do you select unique values in sql?

997

---

Is it possible to pass parameters to triggers?

1099

---

What is mutating table error?

1175

---

Is like operator in sql case sensitive?

1021

---

What is application trigger?

993

---