what are Triggers?




Answers were Sorted based on User's Feedback



what are Triggers?..

Answer / kaarthi v

Triggers are the database objects (Like Procedures) which
will be executed by the Database itself and cannot be
excuted by the user explicitly. The trigger can be written
to execute while inserting/ updating/ deleting a row.

Two types of triiger

ROW LEVEL TRIGGER
===============
Row Level triggers are FOR EACH ROW, that is, the trigger
is activated for each row that is inserted/updated/deleted.

STATEMENT LEVEL TRIGGER
=====================
Statement level triggers will execute the action specified
only once. (Will not consider the no. of rows being
inserted/updated/deleted)

Is This Answer Correct ?    12 Yes 0 No

what are Triggers?..

Answer / akn

Triggers are basically used to implement business rules.
Triggers are also similar to stored procedures.The
difference is that it can be activated when data is added
or edited or deleted from a table in a database.

Is This Answer Correct ?    2 Yes 1 No

what are Triggers?..

Answer / jamuna

triggeres are databbase objects this are stored inthe
data base same as the procedures but procedures executed
explicitely byt triggers executed implicitely when
trigger event occures
triggere event means DML OPERATIONES (INSERT,UPDATE,DELETE)

Is This Answer Correct ?    0 Yes 0 No




what are Triggers?..

Answer / sreekanth

Can anyone tell me in which scenarios row and statement lever can be used?

Is This Answer Correct ?    0 Yes 0 No

what are Triggers?..

Answer / suresh

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Oracle General Interview Questions

what diffrence between function and procedure?

4 Answers  


I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   Wipro, IBM,


when i run my query on yesterday it is fast but today it is slow why?

1 Answers  


what is a view?

7 Answers  


what are different types of locks?

6 Answers  






What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  


How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  


How you find out version of installed workflow?

1 Answers  


What is a Public Synonyms ?

1 Answers  


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

0 Answers   Zensar,


What is an Index Segment ?

2 Answers  


i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  






Categories