create or place procedure aa(time1 in varchar2,time2 in varchar2)
is
v_time1 varchar2(100);
v_time2 varchar2(100);
c_c integer;
c_sql varchar2(500);
c_r integer;
v_time1:=to_date(time1,'yyyymmdd');
v_time2:=to_date(time2,'yyyymmdd');
c_sql:='insert into a1 select * from b1 where date_time>='||v_time1||' and date_time<='||v_time2;
c_c:=dbms_sql.open_cursor;
dbms_sql.parse(c_c,c_sql,dbms_sql.native);
c_r:=dbms_sql.execute(c_c);
dbms_sql.close_cursor;
end ;出现问题是SQL语句未结束,条件里的时间判断应该如果写呢。 c_sql:='insert into a1 select * from b1 where date_time>='||v_time1||' and date_time<='||v_time2;
谢谢!!!
is
v_time1 varchar2(100);
v_time2 varchar2(100);
c_c integer;
c_sql varchar2(500);
c_r integer;
v_time1:=to_date(time1,'yyyymmdd');
v_time2:=to_date(time2,'yyyymmdd');
c_sql:='insert into a1 select * from b1 where date_time>='||v_time1||' and date_time<='||v_time2;
c_c:=dbms_sql.open_cursor;
dbms_sql.parse(c_c,c_sql,dbms_sql.native);
c_r:=dbms_sql.execute(c_c);
dbms_sql.close_cursor;
end ;出现问题是SQL语句未结束,条件里的时间判断应该如果写呢。 c_sql:='insert into a1 select * from b1 where date_time>='||v_time1||' and date_time<='||v_time2;
谢谢!!!
解决方案 »
- 【100分在线】如何克隆oracle的所有东东?
- UNION和UNION ALL的区别
- oracle内存占用不断增长问题
- '' = null?
- 如何使用pl/sql直接对oracle的表进行操作?
- 如果一台机器上安装了oracle数据库那么还需安装客户端码
- 那个更快
- 用DTC从MS SQL server导到oracle每次导到20001行就出错了,为什么?
- oracle中有没有类似sqlserver中的用于备份与恢复的存储过程,可用于jsp开发?不胜感激。
- 选择数据库服务器(硬件)应该考虑哪些因素?
- LONG ROW字段怎么处理?
- 在ORACALE9 中怎么样写SQL语句,删除同一表中的相同记录,只保留一条数据。
is
v_time1 varchar2(100);
v_time2 varchar2(100);
c_c integer;
c_sql varchar2(500);
c_r integer;
v_time1:=to_date(time1,'yyyymmdd');
v_time2:=to_date(time2,'yyyymmdd');
c_sql:='insert into a1 select * from b1 where date_time>='''||v_time1||''' and date_time<='''||v_time2||'''';
c_c:=dbms_sql.open_cursor;
dbms_sql.parse(c_c,c_sql,dbms_sql.native);
c_r:=dbms_sql.execute(c_c);
dbms_sql.close_cursor;
end ;这样
place 要改为replace