we can use 'instead of trigger' for views. using these 'inst

What is INSTEAD OF trigger ?

Question Posted / bikram samal

Answer Posted / bikram samal

we can use 'instead of trigger' for views. using these 'instead of trigger' we can perform DML operation on a complex view.

Is This Answer Correct ?

12 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is on delete restrict?

939

What does pl sql stand for?

1062

What is record variable?

920

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

992

Can a primary key be a foreign key?

968

what is the difference between inner and outer join? Explain with example. : Sql dba

970

When can we use the where clause and the having clause?

966

What is sqlite used for?

933

what are the different index configurations a table can have? : Sql dba

936

how many sql dml commands are supported by 'mysql'? : Sql dba

1053

what is a trigger in mysql? Define different types of trigger. : Sql dba

1009

What is the difference between the implicit and explicit cursors?

990

What are the various restrictions imposed on view in terms of dml?

907

How to call a javascript function from pl sql?

1065

Is left join same as inner join?

1019