We cannot update the view directly if the viw define with more than one ta

What is INSTEAD OF trigger ?

Question Posted / anil siddi

Answer Posted / anil siddi

We cannot update the view directly if the viw define with
more than one table(objects).By using Instead of triggers we
can do that

Is This Answer Correct ?

19 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the most restrictive isolation level? : Transact sql

1085

How many commands are in sql?

1070

Name three sql operations that perform a sort.

1013

Is oracle and sql same?

1010

What is case function?

1040

List the different type of joins?

1061

What are aggregate functions in sql?

1160

What are the uses of sysdate and user keywords?

1104

What is difference between sql and oracle?

1130

what are all types of user defined functions? : Sql dba

1042

What is benefit of creating memory optimized table?

972

Can function return multiple values in sql?

1058

What is the difference between cross join and natural join?

1022

What is sql rowcount?

1020

Explain what is an index?

1056