[SQL데이터타입,레코드타입,오라클자바커뮤니티학원]PLSQL예제]RECORD TYPE예제, PLSQL 데이터타입, 복합데이터타입 ,오라클학원,SQL학원

[SQL데이터타입,레코드타입,오라클자바커뮤니티학원]PLSQL예제]RECORD TYPE예제, PLSQL 데이터타입, 복합데이터타입 ,오라클학원,SQL학원

SQL> CREATE OR REPLACE PROCEDURE displayEmp
  2  (p_empno  IN NUMBER)
  3  IS
  4    TYPE emp_record_type is record
  5    (empno emp.empno%type,
  6    ename emp.ename%type);
  7    emp_record emp_record_type;
  8  BEGIN
  9    SELECT empno, ename
 10      INTO emp_record.empno, emp_record.ename
 11      FROM emp
 12    WHERE empno = p_empno;
 13    DBMS_OUTPUT.PUT_LINE(emp_record.empno || ':' || emp_record.ename );
 14  EXCEPTION
 15    WHEN NO_DATA_FOUND THEN
 16        DBMS_OUTPUT.PUT_LINE('no data...');
 17    WHEN TOO_MANY_ROWS THEN
 18        DBMS_OUTPUT.PUT_LINE('to many rows...');
 19  END displayEmp;
 20  /

Procedure created.

SQL> exec displayEmp(7369);
7369:SMITH

PL/SQL procedure successfully completed.


SQL> exec displayEmp(3333);
no data...

PL/SQL procedure successfully completed.

[출처] 오라클자바커뮤니티 - http://www.oraclejavacommunity.co.kr/bbs/board.php?bo_table=LecSQLnPlSql&wr_id=227

평일주간[100%환급과정] (8/08)Spring,MyBatis,Hibernate실무과정 (8/08)C#4.0,WinForm,ADO.NET (8/11)SQL기초에서 Schema Object까지 (8/11)채용예정교육 (8/18)자바기초JDBC,Servlet/JSP까지 (8/18)안드로이드개발자과정 (8/18)PL/SQL,ORACLE HINT,TUNING 평일야간[개인80%환급] (8/06)JSP,jQUERY,Spring,MyBatis (8/08)C#,Network,ADO.NET,ASP.NET (8/11)SQL기초에서실무까지 (8/11)안드로이드개발자과정 (8/12)Spring, MyBatis, Hibernate (8/13)HTML5,CSS3,Ajax,jQuery마스터 (8/28)자바JSP,jQuery,Spring,MyBatis 주말주간[개인80%환급] (8/09)SQL기초에서실무까지 (8/09)안드로이드개발자과정 (8/09)자바JSP,Ajax,jQuery,Spring,MyBatis (8/16)C#,ASP.NET마스터 (8/16)웹퍼블리싱 마스터 (8/16)Spring, MyBatis, Hibernate (8/23)JAVA,Network&WEB&Framework 주말야간[개인80%환급] (8/09)SQL기초에서실무까지 (8/23)JAVA,Network&WEB&Framework