if you update view? where we store the data?
Answer Posted / vishal muthal
View is nothing but the virtual table made from few columns
of the base table to get faster retrival and fetch of the
data. Hence when you update any view the column which you
updating is get updated,and the column basically belongs to
the base table.hence answer is IT WILL UPDATE BASE TABLE
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
can u plz provide me oca sql dumps please i need them
What is the usage of control file in oracle?
How to use subqueries in the from clause in oracle?
How to view existing locks on the database?
How to check the server version in oracle?
What is difference between truncate and delete?
How to use existing values in update statements using oracle?
What is the difference between pre-select and pre-query?
Explain what are the uses of rollback segment?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to select an oracle system id (sid)?
What happens if the imported table already exists?
What are the general rules on data consistency?
How to run create database statement?
What is using clause and give example?