SQL> declare 2 v_name varchar2(100) := 'NONE'; 3 begin 4 5 with t as ( select '홍길동' name 6 from dual 7 union all 8 select '신사임당' name 9 from dual ) 10 select name 11 into v_name 12 from t; 13 14 dbms_output.put_line('이름(ok) :'||v_name); 15 exception 16 when others then 17 dbms_output.put_line('이름(exception) :'||v_name); 18 end; 19 / 이름(exception) :홍길동 PL/SQL 처리가 정상적으로 완료되었습니다.