[cap-talk] capabilities for databases and database-like systems
john.carlson3 at sbcglobal.net
Sat Apr 9 13:46:19 EDT 2005
>> 2. In most DB systems, There are restrictions on the operations that can
>> be performed using views. That is, views were added as an afterthought
>> rather than as an essential model.
> The restrictions on operations that can be performed on views are
> essential to the function of views, not just some omission because
> views are an "afterthought". In particular views can be composed
> of joins of other tables. If one is then going to update a view, which
> table or what from the tables gets updated?
You can put the keys to the underlying table in the view, and then
the underlying tables will get updated. At least according to one
Oracle expert I talked to. I've never tried it myself.
More information about the cap-talk