Posts by Rafael • 51 points
3 posts
-
1
votes1
answer54
viewsQ: 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',…
-
1
votes2
answers93
viewsQ: 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?…
-
3
votes1
answer93
viewsQ: 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…