1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

If we update a complex view, is base table will get update ?

Question Posted / sunilks

Answers were Sorted based on User's Feedback



If we update a complex view, is base table will get update ?..

Answer / dinesh

Yes We can update base table through complex view
Using "Instead of trigger"

Is This Answer Correct ?    6 Yes 1 No

If we update a complex view, is base table will get update ?..

Answer / zeeshan

Yes one can update complex view where base table data will get affect but few constraint are there like view does not have group by ,order by , or N level function like Rank, dense Rank and Rownumer partition by etc

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

what is foreign key? : Sql dba

0 Answers  

How are sql commands classified?

0 Answers  

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

What is rtm stands for?

0 Answers  

define join and explain different type of joins? : Sql dba

0 Answers  




write a query to delete similar records in different tables with same structure

4 Answers  

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

what are the different type of sql's statements ? : Sql dba

0 Answers  

Explain spool.

0 Answers  

What is cascade in sql?

0 Answers  

What is prepared statement in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories