oracle變量表類型
declare
type my_emp is table of scott.emp%rowtype
index by binary_integer;
new_emp my_emp;
v_num number:=0;
cursor cur_emp is select empno,ename,job,sal from scott.emp;--1.cursor 是個(gè)什么東東?
begin
for v_emp in cur_emp loop --2.v_emp是個(gè)什么東東?怎么和正常for語句不一樣?
v_num:=v_num+1;
select * into new_emp(v_num) from scott.emp
where ename=v_emp.ename; ename --3.和v_ename是哪里來的?
end loop;
for i in 1..new_emp.count loop
dbms_output.put_line(new_emp(i).empno ||','||new_emp(i).ename||','||new_emp(i).job||
','||new_emp(i).sal);
end loop;
end;