Answer / manikandan

1)database trigger
2)application trigger

Answer / sam katwal

There are three types of Triggers
Insert Trigger
Update Trigger
Delete Trigger
One Trigger also exists
Instead of Trigger which was introducted in SQL Server 2000

Answer / ramprakash

Instead of Triggers
After Triggers

Answer / sandeep chawdekar

there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

Answer / anandkumar

DDL and DML Triggers

Answer / arjun singh

INSERT TRIGGER
UPDATE TRIGGER
DELETE TRIGGER

What is sql*plus?

0 Answers  

What is mutating table error?

0 Answers  

What are local and global Indexes and where they are useful.

0 Answers  

Explain what is a subquery ?

0 Answers  

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

Why do we need unique key in a table?

0 Answers  

How many indexes can be created on a table in sql?

0 Answers  

What are different sql data types?

0 Answers  

difference between cursor and procedure in a package

3 Answers   PCS,

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

What is gpt format?

0 Answers  

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers