Interested to Buy Any Domain ? << Click Here >> for more details...
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>>>>
- 1 Answers
- 4440 Views
- Infosys, I also Faced
- E-Mail Answers
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 many anonymous blocks can be defined?
Explain view?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to create a new tablespace in oracle?
How to retrieve the count of updated rows?
Is oracle a programming language?
How do I learn what codesets are available in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to start your 10g xe server?
What is the difference between a user and a schema in oracle?
What happens to the current transaction if the session is ended?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to check database size in Oracle?
How to create a new user account in oracle?
