上面
var1 varchar2(100);
var2 varchar2(100);
var3 varchar2(100);
var4 varchar2(100);
下面fetch v_c into var1 ,var2 ,var3 ,var4
var1 varchar2(100);
var2 varchar2(100);
var3 varchar2(100);
var4 varchar2(100);
下面fetch v_c into var1 ,var2 ,var3 ,var4
declare
type t_varr is varray(20) of varchar2(2);
v_varr t_varr:=t_varr();--构造空数组,没有元素
begin
v_varr.extend(20);--把20个null元素添加到表的末端
for i in 1..20 loop
v_varr(i):=to_char(i);
dbms_output.put_line(v_varr(i));
end loop;
end;
CURSOR c_col IS SELECT * FROM sys.col;
BEGIN
FOR v_rec IN c_col
LOOP
DBMS_OUTPUT.PUT_LINE(v_rec.tname || '.' || v_rec.cname);
END LOOP;
END;