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>>>>
Answer Posted / devraj
The above block will executed successfully.
Because there is no operation performed in any trigger to
use the just inserted rows i mean to say no read and
calcution.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to best split csv strings in oracle 9i?
What is raw datatype in oracle?
How to insert a record into a table?
Give syntax for SQL and ORACLE joins.
What is a oracle database?
What is the dynamic sql in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are the tools for Oracle ?
What is the difference between PFILE and SPFILE in Oracle?
What is rowid and rownum in oracle?
What are the arithmetic operations?
How to create an oracle database manually?
Is the After report trigger fired if the report execution fails ?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??