Posts by Danielscdf • 1 point

• -2

  votes

  2

  answers

  93

  views

  A: Group views in SQL Oracle

  SELECT PQ.CODIGO, PQ.NOME, PQ.USO, DECODE(PA.TIPO, 'REALT', PA.ARQUIVO) AS REALT, DECODE(PA.TIPO, 'BOLET', PA.ARQUIVO) AS BOLET, DECODE(PA.TIPO, 'CHAM', PA.ARQUIVO) AS CHAM FROM PQ,…

  sql database oracle

  answered 7 years, 6 months ago Danielscdf 1