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 auto increment?

0 Answers  

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

How to create an array in pl/sql?

0 Answers  

What is cost in sql execution plan?

0 Answers  

Why use triggers in sql?

0 Answers  




IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

What is scalar data type in pl sql?

0 Answers  

What are the basic techniques of indexing?

0 Answers  

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

What is the location of pre_defined_functions.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories