can we update a view which is created from two tables
- 11 Answers
- 32328 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
It is not possible to update a view which is created from
two tables.Actually when we update any viewtha first the
view has been updated followed by the base table.If we use
instead of trigger then the base be table will updated
first not the view.Because the view is stored in database
as a query.Once the base table will be changed,the view
query will hit the base table and reflects the changes.But
I think that's not the desired answer.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is trigger point?
What is a procedure in pl sql?
Can we rollback after truncate?
How is use pl and sql?
What are the basic sql commands?
Define select, insert, create, delete, update, drop keywords
What is compound trigger?
Explain spool.
Why do we need view in sql?
Which are the different case manipulation functions in sql?
What is trigger in sql? Explain
What is sql analyzer?
How do I sort a table in sql?
explain normalization concept? : Sql dba
What is a database? Explain
