| Re: Trigger [message #373186] |
Mon, 02 April 2001 21:50  |
Sarada
Messages: 27
Registered: April 2001
|
Junior Member |
|
|
|
If the view which you want to be updated is based on the Table which you are going to update then no need to write a trigger it will get updated automatically. Otherwise, after your required updation is done, update the view's base table too. So the view will get updated automatically. Which version of Oracle are you using? If 8 or above, you have a facility to write triggers on the views itself. It is called "Instead of Triggers" Check out the Doc.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
