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

Which table is left in join?

978

---

What is the use of & in pl sql?

1046

---

How do you select unique values in sql?

997

---

What is rtm stands for?

1098

---

How would you convert date into julian date format?

1004

---

What is pl sql script?

1031

---

Is a secondary key the same as a foreign key?

1037

---

Is left join inner or outer?

1014

---

What is sql profiling in oracle?

1064

---

What does the acronym acid stand for in database management?

1032

---

What are pl sql data types?

1010

---

What is the difference between delete, truncate and drop command?

1151

---

explain normalization concept? : Sql dba

1046

---

What is basic structure of pl sql?

1068

---

What is sql and also describe types of sql statements?

1066

---