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 see the table columns used in an index?
What is format trigger?
How to define an oracle sub procedure?
How to execute a stored procedure in oracle?
How to use subqueries with the exists operator in oracle?
What is the relation of a user account and a schema?
What is an anonymous block?
Explain the use of constraints option in exp command.
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a cursor and what are the steps need to be taken?
How to invoke the data pump export utility?
Why packages are used in oracle?
What are the restrictions on external table columns?
How to export your own schema?
what are actual and formal parameters?