Posts by Alexandre Brito • 16 points
1 post
-
0
votes2
answers1401
viewsA: Oracle Update with Join - ORA-01779
One way to solve is by using MERGE oracle to do this. It would look something like: MERGE INTO PROCEDIMENTO_PACIENTE PP USING (select PPR.NR_PRESCRICAO, PPR.NR_SEQUENCIA, LP.CD_MEDICO_RESP from…