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

How to start oracle sql developer?

0 Answers  

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

What is the difference between join and natural join?

0 Answers  

what are all the common sql function? : Sql dba

0 Answers  

What is a column in a table?

0 Answers  




What are conditional predicates?

0 Answers  

What is an example of translating a date into julian format?

0 Answers  

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

Can you join views in sql?

0 Answers  

What is the difference between microsoft access and sql?

0 Answers  

What does t sql mean?

0 Answers  

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories