| ashish |
Posted: Apr 11, 2008 11:53:43 PM |
Total Post: 14
Joined: Dec, 2007
|
hi friends
when we add/modify/delete data in view than it reflects on the base table or not?
if yes than how it happens? |
|
|
 Gitesh |
| Posted: Apr 12, 2008 03:24:22 AM |  |
|
Total Post: 322
Joined: May, 2005
|
Remember one thing that view is logical segment. There is no physical identity of view. Only definition of view is stored in data dictionary. Physical segment is table only. When ever we modify data of view that time base table's data will be modify only.
For materialized view some thing different story because this type of view is physical stored in tablespace/datafile.
|
|
|
|
|
| nag |
| Posted: Apr 21, 2008 03:20:19 AM | |
|
Total Post: 4
Joined: Apr, 2008
|
whatever u made changes in view are reflected to the base table.It is possible if u r view is related with single table otherwise it will through an exception..
|
|
|
|
|
| RAJNISH |
| Posted: Apr 25, 2008 07:18:48 AM | |
|
Total Post: 82
Joined: Jan, 2007
|
dear,
you can insert , update and delete as well in view.
you pass DML statement via TRIGGER TYPE IS INSTEAD OF VIEW.
YOU CAN NOT PASS DML STATEMENT THROUGH NORMAL QUERY.
--Rajnish
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
