1.
set serveroutput on
declare
v_gid scott.goods.g_id%type;
cursor cur_goods207 is
select g_id from scott.goods;
begin
open cur_goods207;
fetch cur_goods207 into v_gid;
dbms_output.put_line(v_gid) ;
close cur_goods207;
end;
set serveroutput on
declare
v_gid scott.goods.g_id%type;
cursor cur_goods207 is
select g_id from scott.goods;
begin
open cur_goods207;
fetch cur_goods207 into v_gid;
dbms_output.put_line(v_gid) ;
fetch cur_goods207 into v_gid;
dbms_output.put_line(v_gid) ;
close cur_goods207;
end;
2.
set serveroutput on
declare
cursor cur_goods207 is
select g_id from scott.goods;
begin
for i in cur_goods207 loop
dbms_output.put_line(I._g_id );
END loop;
end;
3.
set serveroutput on
declare
cursor cur_goods207凌健裕