4_REF_1.SQL

DECLARE 
	REC_EMP EMP%ROWTYPE;
	V_EMPNO EMP.EMPNO%TYPE;
BEGIN
	--1개의 ROW를 SELECT해서 RECORD에 저장
	SELECT * INTO REC_EMP FROM EMP WHERE EMPNO = 7369;

	DBMS_OUTPUT.PUT_LINE('EMPNO => '||REC_EMP.EMPNO);
	DBMS_OUTPUT.PUT_LINE('ENAME => '||REC_EMP.ENAME);
	DBMS_OUTPUT.PUT_LINE('JOB => '||REC_EMP.JOB);
	DBMS_OUTPUT.PUT_LINE('MGR => '||REC_EMP.MGR);
	DBMS_OUTPUT.PUT_LINE('HIREDATE => '||REC_EMP.HIREDATE);
	DBMS_OUTPUT.PUT_LINE('SAL => '||REC_EMP.SAL);

	--RECORD의 개개의 FIELD를독립적으로 사용가능
	SELECT EMPNO,ENAME INTO V_EMPNO,REC_EMP.ENAME
	FROM EMP
	WHERE EMPNO = 7369;

	DBMS_OUTPUT.PUT_LINE('------------------------------------');
	DBMS_OUTPUT.PUT_LINE('EMPNO => '||V_EMPNO);
	DBMS_OUTPUT.PUT_LINE('EMPNO => '||REC_EMP.ENAME);
END;
/