Home » SQL & PL/SQL » SQL & PL/SQL » UPDATE/ INSERT in merge
UPDATE/ INSERT in merge [message #231014] Fri, 13 April 2007 12:45 Go to next message
deep_oracle
Messages: 3
Registered: April 2007
Junior Member
Hi All,

Is it possible to identify whether it is a UPDATE OR INSERT in
MERGE statemnt?

Thanks in advance

Re: UPDATE/ INSERT in merge [message #231017 is a reply to message #231014] Fri, 13 April 2007 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a trigger on your table.

Regards
Michel
Re: UPDATE/ INSERT in merge [message #231024 is a reply to message #231017] Fri, 13 April 2007 13:14 Go to previous messageGo to next message
deep_oracle
Messages: 3
Registered: April 2007
Junior Member
Hey Michel Thanks for your reply..

I was wondering if theres any provision to identify it in merge statment itself, as i just want to identify it(insert/update ) to give the error message which action failed..
so i don want to go for triggers..
I cant use merge i suppose..

Thanks again..
Re: UPDATE/ INSERT in merge [message #231026 is a reply to message #231024] Fri, 13 April 2007 13:21 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No It can't be done inside the merge itself.

Regards
Michel
Previous Topic: deadlock in table
Next Topic: ORA-01843: not a valid month error
Goto Forum:
  


Current Time: Mon Dec 05 12:52:42 CST 2016

Total time taken to generate the page: 0.26426 seconds