MERGE ..!!!

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Thu, 09 Mar 2006 4:26 pm

I'M USING THE MERGE IN A PROCEDURE TO MAKE AN INSERT IF THERE IS NO REGISTRATION OR AN UPDATE IF IT EXISTS. SO THAT CAN OCCUR THERE IS THE RECORD IN THE TABLE, AND THE TRIGGER STOP THE UPDATE DUE TO A VALIDACAO. IF THE TRIGGER BAR WANT TO INSERT INTO ANOTHER TABLE .... CAN SOMEONE HELP ME???? :D
mello
Location: sp

Poston Fri, 10 Mar 2006 1:54 pm

Jeez ... guess I wouldn't use MERGE in this case:-(
I think I'd do manually: shock:
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered



Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 12 guests