2008-04-01 20:36:53 / Oracle开发
java 调oracle自定义函数?例如调用:create or replace functionfind_date(d1 varchar2,n number)return varchar2 ismyexce exception;cursor mycur is select trade_datefrom trade_date_h;rntrade_date_h%ROWTYPE;TYPE ename_table_type IS TABLE OF trade_date_h.trade_date%TYPEINDEX BY BINARY_INTEGER;myett ename_table_type;i number;myc number;flag number;begini:=1;myc:=1;
查看(200)
评论(4)