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
How to revoke create session privilege from a user in oracle?
How to execute the package in oracle?
How to delete an existing row from a table in oracle?
What is flashback in Oracle?
Use of an integrity constraint is better to validate data. Explain
What is SQL access advisor in Oracle?
What is a database schema in oracle?
How to add another datafile to a tablespace?
Differentiate between pre-select and pre-query?
What are named parameters?
What is different types of joins?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Difference between open_form and call_form in oracle.
WHAT IS ecc 6.0
Why does Oracle not permit the use of PCTUSED with indexes?