declare
type job_type is table of emp.job%type;
emp_job job_type;
begin
emp_job := job_type('학생', '회사원', '변호사', '교사');
p(emp_job(1));
p(emp_job(4));
end;
/
declare
type job_type is table of emp.job%type;
emp_job job_type := job_type('학생', '회사원', '변호사', '교사');
begin
p(emp_job(1));
p(emp_job(4));
end;
/
'Oracle > PL/SQL' 카테고리의 다른 글
15일차 # 7-5: Controlling Explicit Cursors (0) | 2012.04.24 |
---|---|
15일차 # 7 - Explicit Cursors (0) | 2012.04.24 |
15일차 # 6-26: 추가 BULK COLLECT (0) | 2012.04.24 |
15일차 # 6-20: Using Collection Methods (0) | 2012.04.24 |
15일차 # 6-15: PL/SQL Collections (0) | 2012.04.24 |