Interested to Buy Any Domain ? << Click Here >> for more details...
can we update a view which is created from two tables
- 11 Answers
- 34394 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
Can you have a foreign key without a primary key?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
explain about mysql and its features. : Sql dba
What is the usage of sql functions?
What is sql mysql pl sql oracle?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is the use of non clustered index?
What is the difference between subquery and correlated query?
How can a function retun more than one value in oracle with proper example?
What are field types?
What is pivot query?
What are some emotional triggers?
What is a sql instance vs database?
Which is faster truncate or drop?
What is java sql driver?
