Posts by Rafael • 51 points

• 1

  votes

  1

  answer

  54

  views

  Q: Doubt with "pivot" ORACLE

  I would like to know how to put the fields CODIGO_PROCESSO, NOME_PRODUTO_PROCESSO and APROVADO_USO in the main select to show in my query SELECT CODIGO_PROCESSO, MAX (DECODE (tipo_arquivo, 'BT',…

  sql database oracle

  asked 8 years ago Rafael 51

• 1

  votes

  2

  answers

  93

  views

  Q: Group views in SQL Oracle

  I’m having a little logical reasoning block. I have a table (Tabela1) organized this way, but I would need to return the query as the table2 below. Someone can help me?…

  sql database oracle

  asked 8 years ago Rafael 51

• 3

  votes

  1

  answer

  93

  views

  Q: Group SQL queries

  I have these queries below, independent, and I’m having difficulty grouping them a same query result, IE, leave the 6 columns requested by select in the same consultation. SELECT codigo_processo…

  sql oracle

  asked 8 years ago Rafael 51