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

Why query optimization is needed?

971

---

What is keys and its types?

1120

---

What are the different set operators available in sql?

1077

---

Why is nosql good?

1079

---

how can we find the number of rows in a table using mysql? : Sql dba

1123

---

What are the most important characteristics of pl/sql?

1224

---

what is cross join? : Sql dba

1046

---

Is primary key clustered or nonclustered?

1059

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2546

---

what is user defined functions? : Sql dba

1084

---

What are the main features of cursor?

1108

---

How do you select unique values in sql?

1043

---

What does the file extension accdb stand for?

1013

---

What are pl/sql cursors?

1098

---

What is scalar and vector?

1060

---