declare
begin
for i in 0..5 loop
for k in 1..i loop
dbms_output.put(' ');
end loop;
for j in 1..11-2*i loop
dbms_output.put('*');
end loop;
dbms_output.put_line('');
end loop;
end;
i,j,k都不必先申明再使用
declare
pename emp.ename%type;
pdname dept.dname%type;
cursor cur_info is select ename,dname from emp,dept where emp.deptno = dept.deptno;
begin
open cur_info;
loop
fetch cur_info into pename,pdname;
exit when cur_info%notfound;
dbms_output.put_line('员工姓名:'||pename||' 部门名称:'||pdname);
end loop;
close cur_info;
end;
在这里pename和pdname必须要申明
求解答!!
没有个大神给点提示吗
和或许是强类型吧,它有int.char.......