| maneesh |
Posted: Aug 09, 2007 08:49:19 AM |
Total Post: 13
Joined: Aug, 2007
|
hi all
i wanna know that r views updatable? suppose a view is created on two tables then in which conditions dml operations can be performed on table though view?
|
|
|
Mohammed Taj |
| Posted: Aug 09, 2007 08:57:10 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
There are two types of view
1. simple views
2. complex views
simple view based on single tables and you can perform DML operations on it.
complex view based on more than one tables and there some condition apply for perform DML operations
http://tahiti.oracle.com
check it out.
Regards
Taj
|
|
|
|
|
Ramesh Joyisa |
| Posted: Aug 10, 2007 07:17:55 AM | |
|
Total Post: 245
Joined: Aug, 2007
|
Yes,We can update. simple views directly, and you can create an INSTEAD OF trigger on any view to make it updatable
|
|
|
|
|
maneesh |
| Posted: Aug 10, 2007 08:40:35 AM | |
|
Total Post: 13
Joined: Aug, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |