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 difference between inner join and self join?

586

Give the order of sql select?

606

What is a function in oracle pl sql?

535

Does pl sql work in mysql?

529

How to use sql statements in pl/sql?

578

Explain spool.

680

explain advantages of myisam over innodb? : Sql dba

595

Why do we use procedures?

508

Explain aggregate functions are available there in sql?

532

What are tables in sql?

542

What are secondary keys?

555

What is rank () in sql?

528

What is transaction control language (tcl)?

630

How do I add a database to sql?

570

What are keys in sql?

541