Posts by Pedro Henrique • 1 point

• 0

  votes

  2

  answers

  59

  views

  A: I’m a beginner in SQL. I need to build an Insert that will validate some fields of the source table and fill in the target table

  In this case just use the merge. merge into Produtos p using (Produtos_temp temp) on (temp.V_ISS = temp.V_total * temp.V_Aliquota /100) when matched then update set p.Data_Validacao = null when not…

  sql oracle

  answered 3 years, 3 months ago Pedro Henrique 1