Interested to Buy Any Domain ? << Click Here >> for more details...
if you update view? where we store the data?
- 5 Answers
- 10934 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 |
What is bulk copy or bcp in oracle?
Can objects of the same schema reside in different tablespace?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
17. Display the order number and average item cost for each order.
20. Using a set operator, display the client number of all clients who have never placed an order.
which language is used to develop the oracle........?
What is Network Database link ?
How to create additional tablespaces for an new database?
How to login to the server without an instance?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
When a form is invoked with call_form, Does oracle forms issues a save point ?
What is a table in oracle?
Oracle General 
