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
How to insert multiple rows with one insert statement in oracle?
What is the usage of synonyms?
What is clustered table in Oracle?
How to end the current transaction in oracle?
How to rename an index?
How to create a new view in oracle?
What is difference between cartesian join and cross join?
How do I escape a reserved word in oracle?
What is the difference between view and materialized view in Oracle?
What is a lookup table in oracle?
what is insert all statement in sql
What is integrity and what is constraint??Explain with example
What happens in oracle commit?
State some uses of redo log files?
What is the use of oracle?