If we update a complex view, is base table will get update ?
Answer Posted / 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 View All Answers
What is not in sql?
How does left join work in sql?
how to use 'mysql' to run sql statements? : Sql dba
Can we join two tables without common column?
What is sqlcommand?
What is sql deadlock?
What is difference between db2 and sql?
what is a control file ? : Sql dba
How delete a row in sql?
Why use triggers in sql?
Are subqueries faster than joins?
how can we repair a mysql table? : Sql dba
What is clause?
Is pl sql and postgresql same?
How can I make sql query run faster?