WITH TEST AS
(
SELECT 'aaa001' usrId,    '홍길동' usrNm,    'seq00001' issSeq,    '20051027' issDt,    '10' issCd,    '20051027' appDt,NULL canDt,'전남' place FROM DUAL
UNION ALL
SELECT 'aaa001',    '홍길동',    'seq00002',    '20121026',    '20',    NULL,'20121026'  ,'전남' FROM DUAL
UNION ALL
SELECT 'aaa002',    '이순신',    'seq00003',    '20061222',    '10',    '20061222',NULL ,'전남' FROM DUAL
UNION ALL
SELECT 'aaa002',    '이순신',    'seq00004',    '20121221',    '20',    NULL,'20121221'  ,'전남' FROM DUAL
UNION ALL
SELECT 'aaa004',    '김홍동',    'seq00005',    '20061018',    '10',    '20061018',NULL ,'전남' FROM DUAL
UNION ALL
SELECT 'aaa004',    '김홍동',    'seq00006',    '20121017',    '20',    NULL,'20121017'  ,'전남' FROM DUAL
UNION ALL
SELECT 'aaa005',    '최자 ', 'seq00007',    '19981101',    '10',    '19981101',NULL ,'서울' FROM DUAL
UNION ALL
SELECT 'aaa005',    '최자 ', 'seq00008',    '20121204',    '20',    NULL,'20121204'  ,'서울' FROM DUAL
UNION ALL
SELECT 'aaa007',    '이미 ', 'seq00009',    '20010704',    '10',    '20010704',NULL ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa007',    '이미 ', 'seq00010',    '20060921',    '20',    NULL,'20060921'  ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa007',    '이미 ', 'seq00011',    '20060921',    '10',    '20060921',NULL ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa007',    '이미 ', 'seq00012',    '20120920',    '20',    NULL,'20120920'  ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa008',    '박호 ', 'seq00013',    '20060912',    '10',    '20060912',NULL ,'충남' FROM DUAL
UNION ALL
SELECT 'aaa008',    '박호 ', 'seq00014',    '20120911',    '20',    NULL,'20120911'  ,'충남' FROM DUAL
UNION ALL
SELECT 'aaa006',    '김길동',    'seq00015',    '20001006',    '10',    '20001006',NULL ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa006',    '김길동',    'seq00016',    '20061005',    '20',    NULL,'20061005'  ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa006',    '김길동',    'seq00017',    '20061006',    '10',    '20061006',NULL ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa006',    '김길동',    'seq00018',    '20121005',    '20',    NULL,'20121005'  ,'경남' FROM DUAL
UNION ALL
SELECT 'aaa003',    '주최자',    'seq00019',    '20060907',    '10',    '20060907',NULL ,'부산' FROM DUAL
UNION ALL
SELECT 'aaa003',    '주최자',    'seq00020',    '20120906',    '20',    NULL,'20120906'  ,'부산' FROM DUAL
UNION ALL
SELECT 'aaa003',    '주최자',    'seq00021',    '20120907',    '10',    '20120907',NULL ,'부산' FROM DUAL
)
SELECT *
FROM
(SELECT USRID,USRNM,ISSSEQ,ISSDT,ISSCD,
CASE WHEN APPDT IS NULL THEN LAG(APPDT) OVER(PARTITION BY USRID ORDER BY ISSSEQ ASC) ELSE APPDT END AS STARTDT ,
CASE WHEN CANDT IS NULL THEN LEAD(CANDT) OVER(PARTITION BY USRID ORDER BY ISSSEQ ASC) ELSE CANDT END AS ENDDT,
PLACE
    FROM TEST)
WHERE ISSCD='20' OR ENDDT IS NULL
ORDER BY ISSSEQ;

 SQL 문장 

완전히 감사합니당~^^ 해결되었습니당...감사..