| Re: Insert into a view [message #373272] |
Mon, 09 April 2001 04:22 |
Prem
Messages: 79
Registered: August 1998
|
Member |
|
|
jay,
yeah, you can. Depends on the Oracle version you are using. In earlier versions of Oracle, there were certain restrictions on the kind of views which allowed inserts/updates and deletes. The view should not be based on more than 1 table, the primary key should be a part of the view definition, the not null columns must be part of the view definition... However, if you are using the Oracle 8.x version, we have a new INSTEAD OF trigger used on views. This trigger can be used to take appropriate actions when there is an insert/update/delete on the view. and hence, most of the restrictions in the earlier versions can be overcome by this. I haven't used one, but you should be able to get some examples in the online doc.
hth
Prem :)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
