Home » SQL & PL/SQL » SQL & PL/SQL » Re: Update trigger (Form 6i window 7 ultimate(32))
Re: Update trigger [message #625065] Wed, 01 October 2014 01:34 Go to next message
kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania
Senior Member
Hello fellows

please assist me with this.

I have two tables ;
create table RENTA(
id number(3),
type varchar(30)--AVAILABLE,PENDING,ACTIVE
)
/

create table RENT_USE(
REQ_DATE DATE ,
id number(3),
type varchar(30)--AVAILABLE,PENDING,ACTIVE
)
/

Now I want to write a trigger which will update RENTA.TYPE IF RENTA_USE.TYPE HAS CHANGED WHERE ID=ID.

THANK YOU
Re: Update trigger [message #625067 is a reply to message #625065] Wed, 01 October 2014 01:47 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Please read and follow the OraFAQ Forum Guide and How to use [code] tags, to enable us to help you.

What have you tried so far? You can start from here http://docs.oracle.com/database/121/LNPLS/create_trigger.htm
Re: Update trigger [message #625071 is a reply to message #625065] Wed, 01 October 2014 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

please assist us in formatting your posts as you have been repeatedly asked.

THANK YOU

Re: Update trigger [message #625192 is a reply to message #625071] Thu, 02 October 2014 08:49 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Perhaps this will help...

http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm
http://www.techonthenet.com/oracle/triggers/after_update.php
Craig...

[Updated on: Thu, 02 October 2014 08:54]

Report message to a moderator

Previous Topic: table Data
Next Topic: New developer and facing trouble with a store procedure
Goto Forum:
  


Current Time: Fri Mar 29 10:23:43 CDT 2024