create or replace procedure sp_part_ticketdate(
i_startday in number,
i_endday in number
) is
v_partname varchar2(30);
v_fornum number;
begin
if i_startday<i_endday then
--v_fornum:=i_startday;
v_partname:='part'||to_char(v_fornum);
for v_fornum in i_startday..i_endday loop
alter table tb_dw_ticketdate add partition v_partname values(to_char(v_fornum)); end loop;
end if;
end sp_part_ticketdate;
PROCEDURE SCOTT.SP_PART_TICKETDATE 编译错误错误:PLS-00103: 出现符号 "ALTER"在需要下列之一时:
( begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
行:13
文本:alter table tb_dw_ticketdate add partition v_partname values(to_char(v_fornum));
i_startday in number,
i_endday in number
) is
v_partname varchar2(30);
v_fornum number;
begin
if i_startday<i_endday then
--v_fornum:=i_startday;
v_partname:='part'||to_char(v_fornum);
for v_fornum in i_startday..i_endday loop
alter table tb_dw_ticketdate add partition v_partname values(to_char(v_fornum)); end loop;
end if;
end sp_part_ticketdate;
PROCEDURE SCOTT.SP_PART_TICKETDATE 编译错误错误:PLS-00103: 出现符号 "ALTER"在需要下列之一时:
( begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
行:13
文本:alter table tb_dw_ticketdate add partition v_partname values(to_char(v_fornum));
解决方案 »
- Oracle :安装时的SID与建库时的SID有何区别?
- ORACLE11g, ORA-04098: 触发器无效且未通过重新验证
- oracle long类型查询问题
- Oracle中如何实现缺少日期的填充?
- 怎么在定义变量的过程中初始化值?例如 M_Project_Module_Group RIGHT_SETTING;
- ORACLE这个sql怎么写啊,在线等!!!!!!!!
- oracle 查询两个日期并拼接起来
- 问题急!各位大虾请进阿!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- insert ,update
- 请推荐oracle store procedure的书籍(下载),谢谢!
- oracle分区表建索引默认的问题
- sql中将时间段进行分段的问题
execute immediate 'alter table....';
i_startday in number,
i_endday in number
) is
v_partname varchar2(30);
v_fornum number;
str_sql varchar2(250) :='';
begin if i_startday<i_endday then
--v_fornum:=i_startday;
v_partname:='part'||to_char(v_fornum);
for v_fornum in i_startday..i_endday loop
str_sql:= 'alter table tb_dw_ticketdate add partition'|| v_partname||' values('||to_char(v_fornum)||')';
execute immediate str_sql;
end loop;
end if;
end sp_part_ticketdate;