/* Oracle ==> http://blog.naver.com/hyelee96/140073401311 */ WITH t AS ( SELECT 'A' gbn, '001' val FROM dual UNION ALL SELECT 'A' gbn, '002' val FROM dual UNION ALL SELECT 'A' gbn, '003' val FROM dual UNION ALL SELECT 'A' gbn, '004' val FROM dual UNION ALL SELECT 'A' gbn, '005' val FROM dual UNION ALL SELECT 'A' gbn, '011' val FROM dual UNION ALL SELECT 'B' gbn, '007' val FROM dual UNION ALL SEL..