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 run the anonymous block again?
How to list all user accounts in oracle?
Explain what are the uses of rollback segment?
How to load excel data sheet to oracle database
why dont we assign not null constraint as table level constraint.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How can I see all tables in oracle?
what is dynamic SGA and static SGA
What are temporal data types in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the set operators union, union all, minus & intersect meant to do?
How to use like conditions in oracle?
What are the different types of modules in oracle forms?
What is the maximum limit on the number of columns in a table?