Quiz04. [Oracle] 출력값은???

Quiz 04. 출력값은???

 

1. 조건

DECLARE
	V_NAME VARCHAR2(100) := 'NONE';

BEGIN
	WITH TBL AS (
		SELECT '홍길동' AS NM FROM DUAL
		UNION ALL
		SELECT '신사임당' AS NM FROM DUAL
	)
	SELECT NM
	  INTO V_NAME
	  FROM TBL;

	DBMS_OUTPUT.PUT_LINE( '이름 : ' || V_NAME );

EXCEPTION
	WHEN OTHERS THEN
		DBMS_OUTPUT.PUT_LINE( '이름 : ' || V_NAME );

END;

 

 

 

2. 정답은???

1) NONE

2) 홍길동

3) 신사임당

 

 

대박....

 

[출처] 구루비 http://www.gurubee.net/article/60882