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

How do I copy a table in sql?

983

---

What is sql performance tuning?

916

---

Is subquery faster than join?

1010

---

Explain the difference between rename and alias?

1010

---

In pl/sql, what is bulk binding, and when/how would it help performance?

993

---

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

1151

---

How to pronounce postgresql?

1055

---

Can a commit statement be executed as part of a trigger?

1048

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1087

---

How do I run a query in pl sql developer?

993

---

What is indexes?

1056

---

What is a clob in sql?

1015

---

Does execute immediate commit?

1216

---

What is recursive join in sql?

1004

---

What is the maximum size of sqlite database?

1102

---