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 happens if you set the sga too low in oracle?
How to manage transaction isolation level?
what is the difference between data migration and production migration.
Give syntax for SQL and ORACLE joins.
Explain the blob datatype?
what is IDE,DMV in sql server?
List the various oracle database objects?
How to execute the package in oracle?
What is a view and how is it different from a table?
How to create a new table by selecting rows from another table?
How to define a data field as not null?
What is query image?
How are extents allocated to a segment?
How to create a temporary table in oracle?
Point out the difference between user tables and data dictionary?