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
Will you be able to store pictures in the database?explain.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is oracle join syntax?
Who developed oracle & when?
How to connect the oracle server as sysdba?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What privilege is needed for a user to create tables in oracle?
Explain a data segment?
What is procedure overloading in oracle?
What is an Oracle index?
How to create id with auto_increment on oracle?
What is meant by a deadlock situation?
Explain the use of grant option in exp command.
Explain what are clusters?
Why do we need integrity constraints in a database?