can we update a view which is created from two tables
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 are literals in sql server?
What is nosql vs sql?
What is the difference between microsoft sql and mysql?
What are pl sql procedures?
What is the order of sql select?
What is a join query?
what is csv? : Sql dba
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Explain foreign key in sql?
Is record in oracle pl sql?
What are commit, rollback, and savepoint?
What is difference between joins and union?
Can you have more than one key in a database?
when MSQL8.0 is in market
How do I count records in sql?