dbms_output.putline(‘i=‘+i);end LOOP; end;
oracle创建存储过程
标签：procedure create oracle har oop select href end sele
oracle创建存储过程
OR REPLACE
procedure "INSERT_MONTH_BATTERYDATA_MONTH"(
YEAR IN number ,
MONTH IN number
)
as
DAY varchar2(40):=0;
i number(20);
begin
-- select (add_months(to_date(YEAR||MONTH, ‘YYYYMM‘),1)-to_date(YEAR||MONTH, ‘YYYYMM‘)) into DAY from dual;--月份的天数计算出来
for i in 1..DAY LOOP
dbms_output.putline(‘i=‘+i);end LOOP; end;
dbms_output.putline(‘i=‘+i);end LOOP; end;