Home » Other » Training & Certification » TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST (Oracle 10g ,XP)
TRIGGER FOR UPDATING ROW IF EXISTS AND INSERT NEW ROW IF ALREADY EXIST [message #310773] Wed, 02 April 2008 06:40 Go to next message
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 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Read this
and this Then try posting a question that adheres to the forum guidelines
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
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 Go to previous message
Barbara Boehmer
Messages: 8625
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.
Previous Topic: getting duplicates from query
Next Topic: syntax issue
Goto Forum:
  


Current Time: Sun Dec 04 00:46:33 CST 2016

Total time taken to generate the page: 0.10694 seconds