if you update view? where we store the data?
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
Explain the use of indexes option in exp command.
What types of joins are used in writing subqueries?
How to create a testing table in oracle?
What is null value in oracle?
Please explain oracle data types with examples?
What is an oracle wallet?
How to compare dates in oracle sql?
What are the tools for Oracle ?
How to use windows user to connect to the server?
What is an oracle database table?
how can we store any pdf file in oracle
How does Oracle guarantee data integrity of data changes?
What is BBED in Oracle?
what is dynamic SGA and static SGA
State all possible different index configurations a table can possibly have?