Posted on 2009-04-01 17:02
bluoy 閱讀(834)
評論(1) 編輯 收藏
下面的例子實現把一個整數的各個位上的數字相加,通過這個例子我們再次理解
connect by.
create or replace function f_digit_add(innum integer) return number
is
outnum integer;
begin
if innum<0 then
return 0;
end if;
select sum(nm) into outnum from(
select substr(innum,rownum,1) nm from dual connect by
rownum<length(innum)
);
return outnum;
end f_digit_add;
/
select f_digit_add(123456) from dual;