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
What is the string concatenation operator in oracle?
How to delete a column in an existing table?
Explain implicit cursor.
Explain the blob datatype?
Can we protect our pl/sql source code?
What is parameterized cursor in oracle?
How to change system global area (sga) in oracle?
Query to retrieve record for a many to many relationship ?
Is there any function in oracle similar like group_concat of mysql?
Hi Can any one tell me what are the API's used in requisition import.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Explain oracle 12c new features for developers?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to create tables for odbc connection testing?
Does oracle partitioning improve performance?