afiedt.buf

来自「codding for pszone one can use it at pl」· BUF 代码 · 共 14 行

declare
cursor c1 is
select max(total),min(total) from mvpstudent;
c_maxtot mvpstudent.total%type;
c_mintot mvpstudent.total%type;
begin
open c1;
fetch c1 into c_maxtot,c_mintot;
dbms_output.put_line('the maximum total is '||c_maxtot);
dbms_output.put_line('the minimum total is '||c_mintot);
close c1;
end;
/