oracle创建存储过程
时间：2021-07-01 10:21:17
帮助过：3人阅读
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;
oracle创建存储过程
标签：procedure create oracle har oop select href end sele
