/*
|| SELECT INTO文
||
|| SELECT <列名> [,<列名>･･･] INTO <変数名> [,<変数名>]
|| FROM <表名>;
*/
SQL> DECLARE
2 e_name emp.ename %TYPE;
3 e_hiredate emp.hiredata%TYPE;
4 BEGIN
5 SELECT e_hiredate INTO e_hiredate
6 FROM emp
7 WHERE empno = 7369;
8 DBMS_OUTPT.PUT.LINE(e_name||’ ‘||e_hiredate);
9 END;
10 /
以上です (^^♪
