Interested to Buy Any Domain ? << Click Here >> for more details...
if you update view? where we store the data?
- 5 Answers
- 11130 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / smrao
Even if we update the view, the data will update in the
base table of the view.
| Is This Answer Correct ? | 26 Yes | 2 No |
in the table itself..view does not contain any data!
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
Answer / sivakumar
The value gets updated in base table. This is done by insteadof trigger
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
How to run create database statement?
How to write a query with a left outer join in oracle?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
How can we find the size of a database?
Which is better Oracle or MS SQL? Why?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
How to call a sub procedure?
What is snapshot is too old? Give and example for better understand.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Why cursor variables are easier to use than cursors?
What are main difference between Stored Procedure and Functions.
Oracle General 
