if you update view? where we store the data?
- 5 Answers
- 9348 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vishal muthal
View is nothing but the virtual table made from few columns
of the base table to get faster retrival and fetch of the
data. Hence when you update any view the column which you
updating is get updated,and the column basically belongs to
the base table.hence answer is IT WILL UPDATE BASE TABLE
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the usage of control file in oracle?
How translate command is different from replace?
How to use fetch statement in a loop?
What privilege is needed for a user to insert rows to tables in another schema?
Explain a segment?
What is oracle instant client?
What is an index associated with a constraint?
What happens if you set the sga too low in oracle?
How to get last row id?
Hi Can any one tell me what are the API's used in requisition import.
How can we find out the current date and time in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is null value in oracle?
Can multiple columns be used in group by in oracle?
State and explain about oracle instance?
