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)

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.

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)

Answer / sreekanth

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

Answer / rocky-455

Triggers are validating data from COLUMNS/TABLE. It handles complex validations.

Answer / kamala k n

triggers types two row and statement

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

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

State all possible different index configurations a table can possibly have?

0 Answers  

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 Answers  

How to see the table columns used in an index?

0 Answers  

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers  

How to delete multiple rows from a table in oracle?

0 Answers  

what is Table ?

2 Answers  

how to get second highest sal of emp table

6 Answers  

Explain the difference between a procedure and a function?

0 Answers  

What is the meaning of recursive hints in oracle?

0 Answers  

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers