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 BBED in Oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Difference between inner join vs where ?
How to export data to a csv file?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is SQL access advisor in Oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What is the implicit cursor in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to create a new table by selecting rows from another table?
What is MTTR advisor in Oracle?
How to assign values to data fields in record variables?
Can we write dml statement in function in oracle?
How to increment dates by 1 in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.