| maneesh |
Posted: Aug 09, 2007 08:45:26 AM |
Total Post: 13
Joined: Aug, 2007
|
hi all
i wanna know that r views updatable? look at the following example:
table emp
id Primary key
name |
|
|
oraclebeanz |
| Posted: Aug 10, 2007 12:25:17 AM | |
|
Total Post: 2
Joined: Dec, 2006
|
we can update view .if the view is created with one table. But we canot update view if the view is created with more than one table with multiple columns.why because view is single virtual table created multiple columns from diffrent tables. so we canot update this virtual table i.e view.when we selected multiple tables and mutiple columns.
|
|
|
|
|
Ramesh Joyisa |
| Posted: Aug 10, 2007 07:16:30 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
|
|
|
|
|
Ramesh Joyisa |
| Posted: Aug 10, 2007 07:16:52 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
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |