Group views in SQL Oracle

Question

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?

Answer 1

What you seek is to turn rows into columns, which can be reached through the PIVOT

I made an example for you to achieve your goal:

create table teste (
  codigo number, 
  nome varchar2(50),
  uso varchar2(10),  
  arquivo varchar2(50), 
  tipo varchar2(50)
);
insert into teste values (10, 'Joao', 'SIM', 'C:JOAO/REALT', 'REALT');

insert into teste values (10, 'Joao', 'SIM', 'C:JOAO/BOLET', 'BOLET');

insert into teste values (10, 'Joao', 'SIM', 'C:JOAO/CHAM', 'CHAM');

Final query:

select * from teste
pivot (
       max(arquivo)
       for tipo in ('REALT'  as REAT,
                    'CHAM'   as CHAM,
                    'BOLET'  as BOLET
      ));

Answer 2

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, PA;