create or replace procedure getCollectionListByCondition
(
startTime date,
endTime date
)
str_sql :=str_sql || ' and lastTime between'||startTime||'and'||endTime||';
我在这里面谢了一句动态sql语句,现在运行时报错误:PLS-00103: 出现符号 ";
(
startTime date,
endTime date
)
str_sql :=str_sql || ' and lastTime between'||startTime||'and'||endTime||';
我在这里面谢了一句动态sql语句,现在运行时报错误:PLS-00103: 出现符号 ";
str_sql :=str_sql || ' and lastTime between '||startTime||' and '||endTime||';
str_sql :=str_sql || ' and lastTime between '||startTime||' and '||endTime||';
已写入 file afiedt.buf 1 select to_date('2010-01-02 03:40:12','yyyy-mm-dd hh24:mi:ss'),
2 to_char(to_date('2010-01-02 03:40:12','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd'),
3* trunc(to_date('2010-01-02 03:40:12','yyyy-mm-dd hh24:mi:ss'),'dd') from dual
SQL> /TO_DATE('2010- TO_CHAR(TO TRUNC(TO_DATE(
-------------- ---------- --------------
02-1月 -10 2010-01-02 02-1月 -10
过程后面 as 没写 begin没写 str_sql 没定义
动态sql都没拼好
(
startTime date,
endTime date
) as
str_sql varchar2(200);
begin
str_sql:='str_sql and lastTime between'|| startTime||'and'|| endTime||'';
end;