prcedure 썸네일형 리스트형 oracle procedure -- table type => 일차원 배열 create or replace procedure table_test(v_deptno in emp.deptno%TYPE) is type empno_table is table of emp.empno%TYPE index by binary_integer; type ename_table is table of emp.ename%TYPE index by binary_integer; type sal_table is table of emp.sal%TYPE index by binary_integer; empno_tab empno_table; ename_tab ename_table; sal_tab sal_table; i binary_integer := 0; begin dbms_o.. 더보기 이전 1 다음