ANY answer.
Re: When is a view updatable in SQL-99?
The answer depends on which database server you are using.
I know Postgres and MySQL do not allow this, even though there are some work arounds for Postgres. I am not sure about the latest MySQL (i.e. version 5.0+), it might be able to update views, but previous versions couldn't.
I believe Oracle and MS SQL can.
|