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

How many developers work on postgresql?

568

---

How subquery works in sql?

543

---

What does the base_object_type column shows in the user.triggers data dictionary view?

576

---

What is nvarchar in sql?

522

---

What is sql and explain its components?

602

---

---

Why use triggers in sql?

505

---

What is union?

651

---

What is union, minus and interact commands?

750

---

What is rename in sql?

555

---

how to concatenate two character strings? : Sql dba

556

---

What is difference between joins and union?

535

---

Which operator is used in query for pattern matching?

629

---

What is sql performance tuning?

497

---

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

579

---

What does desc stand for?

593

---