Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5370 Views
- Ardee Technologies, HCL, I also Faced
- E-Mail Answers
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
In what condition is it good to disable a trigger?
What type of database is cloud sql?
Why do we use procedures?
what is row? : Sql dba
How to create an array in pl/sql?
Differentiate between sga and pga.
Is primary key an index?
Why is sharding used?
Explain about various levels of constraint.
What is view explain with example?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Is full outer join same as cross join?
Which is faster union or join?
What is pessimistic concurrency control? : Transact sql
Define SQL and state the differences between SQL and other conventional programming Languages?
