List the parts of a database trigger.
No Answer is Posted For this Question
Be the First to Post Answer
difference between oracle8i and oracle9i
How to create tables for odbc connection testing?
how to retrieve 1st and last row of table without using group functions??
How many types of synonyms in Oracle?
What are the built-in functions used for sending Parameters to forms ?
What are a cluster and non-cluster index?
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
what are the disadvantages of hierarchial database over RDBMS?
Explain the importance of .pll extension in oracle?
How to assign data of the deleted row to variables?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
what is the difference between restoring and recovering?