create trigger on a view??

Wrox Programmer Forums

		Wrox Programmer Forums > Database > Oracle
create trigger on a view??

Oracle General Oracle database discussions.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

July 26th, 2005, 01:57 PM

timbal25

timbal25 is offline

Authorized User

Join Date: Aug 2003

Posts: 18

Thanks: 0

Thanked 0 Times in 0 Posts

Default

create trigger on a view??

Is it possible to create a trigger on a view? I'm running oracle 9.2 on hpux.

Thanks!

Old

July 26th, 2005, 08:14 PM

AB

AB is offline

Registered User

Join Date: Jul 2005

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Yes, you can create the Instead of trigger. Check the below link for more information.

http://www.psoug.org/reference/instead_of_trigger.html

HTH
AB

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create trigger on update	bvpsekhar	MySQL	23	May 4th, 2007 01:01 AM
need help w/create trigger by an insert operation	jnt	SQL Server 2000	2	December 14th, 2006 07:31 PM
How to create a trigger for this constraint.	method	SQL Server 2000	6	June 30th, 2005 02:57 AM
How to create trigger in StoreProcedure	shailu	SQL Server 2000	5	December 22nd, 2004 12:23 AM
Create Insert Trigger	byron	SQL Server 2000	6	November 19th, 2003 11:30 AM