if you update view? where we store the data?
Answer Posted / ramesh.ch
The updated data will be stored in base table directly.
Explanation:
View is always reference for base table .view is a virtual
table.Unless a view is indexed,its data is not stored in
data base as a distinct element. only the select statement
is stored in the data base.If you call the select statement
of view ,it displays the data form base table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is control file used for?
What is the difference between $oracle_base and $oracle_home?
How to add a new column to an existing table with a default value?
Is oracle a language?
What are the roles of dba?
How to view all columns in an existing table?
How to insert a record into a table?
What is oracle rowcount?
Explain what are clusters?
What is the usage of control file in oracle?
What is a lookup table in oracle?
How to update values on multiple rows in oracle?
How to export several tables together?
What do you understand by a database object? Can you list a few of them?
How to define a specific record type?