Hi,
version 10.2.0.4
using sql below get ORA-01036 - illegal variable name/number
v_sql := q'[
select to_date('05/10/2020 22:22:43','DD/MM/YYYYHH24:MI:SS')
from dual]';
dbms\_output.put\_line(v\_sql);
want to have dynamic sql which has dates such as this - had hoped to use the q delimiter for this but doesn't seem to like.
How can we achieve this with q delimiter- didn't really want to have to use quotes like below a quite alot of dates in the sql concerned.
v_sql := '
select to_date(''05/10/2020 22:22:43'',''DD/MM/YYYYHH24:MI:SS'')
from dual';
dbms\_output.put\_line(v\_sql);
Thanks