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 connection pooling in oracle?
What is oracle and what are its different editions?
Which is better Oracle or MS SQL? Why?
How many types of tables are there in oracle?
How to best split csv strings in oracle 9i?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is max rowid in oracle?
How to connect ms access to oracle servers?
Does oracle database need java?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is key preserved table?
How to open a cursor variable?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is clustered table in Oracle?