if you update view? where we store the data?
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 |
How to get last row id?
how to use sequence and what use of sequence cache
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
when do u go for hash partitioning?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
12. Display the client name in upper case only and in lower case only.
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to sort output in descending order in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Give syntax for SQL and ORACLE joins.
What is the difference between pre-select and pre-query?
Is java required for oracle client?