리스트 쿼리인데..
SELECT a.id , MIN(DECODE(b.id, '001', b.name)) name_001 , MIN(DECODE(b.id, '002', b.name)) name_002 , MIN(DECODE(b.id, '003', b.name)) name_003 , MIN(DECODE(b.id, '004', b.name)) name_004 , MIN(DECODE(b.id, '005', b.name)) name_005 , MIN(DECODE(b.id, '006', b.name)) name_006 , MIN(DECODE(b.id, '007', b.name)) name_007 , MIN(DECODE(b.id, '008', b.name)) name_008 , MIN(DECODE(b.id, '009', b.name)) name_009 , MIN(DECODE(b.id, '010', b.name)) name_010 , MIN(DECODE(b.id, '011', b.name)) name_011 , MIN(DECODE(b.id, '012', b.name)) name_012 , MIN(DECODE(b.id, '013', b.name)) name_013 FROM tableA a , tableB b WHERE a.id = b.p_id(+) GROUP BY a.id ;