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 does data normalization mean?

0 Answers  

What is the source code of a program?

0 Answers  

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

What is sqlca in powerbuilder?

0 Answers  

How do I trace sql profiler?

0 Answers  




How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

28 Answers   Alps, Aricent, Bank Of America, Wipro,

What is sql and explain its components?

0 Answers  

How do I turn a list into a table?

0 Answers  

What is a mutating table and a constraining table?

0 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

Find out the 3rd highest salary?

51 Answers   BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

How to write html code in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories