杨勇.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 23 行

1.
create or replace package yang_yong
is
    function he(n in int)
    return int;
end yang_yong;
create or replace package body yang_yong
is
    function he(n in int)
    return int
    is
        v_sum int:=0;
        i int:=1;
    begin
        for i in 1..n
        loop
            v_sum:=v_sum+i;    
        end loop;
        return v_sum;
    end he;
begin
    null;
end yang_yong;