if you update view? where we store the data?
- 5 Answers
- 9417 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Why use resource manager in Oracle?
What privilege is needed for a user to query tables in another schema?
What happens to the indexes if a table is recovered?
What is connection pooling in oracle?
What is the disadvantage of User defind function?
How to get a list of all user accounts in the database?
What is instant client oracle?
How to write a query with a left outer join in oracle?
What is meant by joins?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
query optmization techniques and quwry analyser+projects+ppts
Can we commit inside a function in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How can windows applications connect to oracle servers?
What is the difference between postgresql and oracle?
