Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5273 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
what is recursive stored procedure? : Sql dba
what are date and time data types? : Sql dba
explain commit and rollback in mysql : sql dba
What is an exception in PL/SQL? What are the two types of exceptions?
What are the limitations of sql express?
What is normalization sql?
Write a unique difference between a function and a stored procedure.
Is hadoop a nosql?
What is difference between my sql and sql?
What is %type in pl sql?
What is bind reference and how can it be created?
What are the possible values that can be stored in a boolean data field?
How do I start sql from command line?
Why is there a need for sqlcode and sqlerrm variables?
Why commit is not used in triggers?
