Answer Posted / kuldeep

CREATE TABLE SOURCE_HIST
AS SELECT SYSDATE CHANGE_DATE, USER_SOURCE.*
FROM USER_SOURCE WHERE 1=2;



CREATE OR REPLACE TRIGGER trig_change_hist
AFTER CREATE ON SCHEMA
BEGIN
INSERT INTO SOURCE_HIST -- History table
SELECT SYSDATE, user_source.*
FROM USER_SOURCE
WHERE NAME = ORA_DICT_OBJ_NAME; --
EXCEPTION
WHEN OTHERS
THEN
raise_application_error (-20000, SQLERRM);
END;
/

What is the difference between functions, procedures, and packages in pl/sql?

1025

---

what is “go” in t-sql? : Transact sql

1088

---

Is there any restriction on the use of union in embedded sql?

1148

---

What is meant by truncate in sql?

1046

---

What is inner join in sql?

1060

---

Can a foreign key have a different name?

933

---

How do you add a column to a table?

1039

---

What does count (*) mean in sql?

1556

---

Describe different types of general function used in sql?

1017

---

What is column?

975

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1194

---

What is dynamic sql in pl sql?

1012

---

What is sql rowcount?

988

---

What is the use of <> sql?

961

---

What is autocommit sql?

969

---