OraFAQ Forum: Training & Certification » TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST

Home » Other » Training & Certification » TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST (Oracle 10g ,XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST [message #310773]

Wed, 02 April 2008 06:40

suneelvarma_27
Messages: 28
Registered: April 2008

Junior Member

Hi all

Can u pls help me to write the trigger for updating salary of emp in a table if empid is already exists, inserts new row if empid is not exists in a table...
thank u

[Updated on: Wed, 02 April 2008 06:47]

Report message to a moderator

Re: TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST [message #310774 is a reply to message #310773]

Wed, 02 April 2008 06:44

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Read this
and this Then try posting a question that adheres to the forum guidelines

Report message to a moderator

Re: TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST [message #310778 is a reply to message #310773]

Wed, 02 April 2008 07:13

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them including what is said about formatting.

As you are an expert, I don't answer the question because you obviously already knows it.

Regards
Michel

Report message to a moderator

Re: TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST [message #310857 is a reply to message #310773]

Wed, 02 April 2008 11:34

Barbara Boehmer
Messages: 9086
Registered: November 2002
Location: California, USA

Senior Member

suneelvarma_27 wrote on Wed, 02 April 2008 04:40

Hi all

Can u pls help me to write the trigger for updating salary of emp in a table if empid is already exists, inserts new row if empid is not exists in a table...
thank u

What you are describing would be done in a procedure, not a trigger.

Report message to a moderator

Previous Topic:	getting duplicates from query
Next Topic:	syntax issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 11:16:07 CDT 2024