oracle变量表类型declaretypemyempistableofscott.emp%rowtypeindexbybinaryinteger;newempmyemp;vnumnumber:=0;cursorcurempisselectempno,ename,job,salfromscott.emp;--1.cursor是个什么东东?beginforvempincuremploop--2.v

Question

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 是个什么东东?
begin
for v_emp in cur_emp loop --2.v_emp是个什么东东?怎么和正常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;

Answer 1

1.cursor指的是游标,这里是定义一个游标,下面for循环中用
2.v_emp是个变量,通过游标cur_emp每次循环取值用的
3.v_emp.ename是游标中查询出来的,就是这句 select empno,ename,job,sal from scott.emp中查到的结果ename