Thank you Sybrand !
Always helpful !
Sybrand Bakker <oradba_at_sybrandb.demon.nl> wrote in message news:<rood2usbkb90gf3oicg2kqvg8pi6566cac_at_4ax.com>...
> On 23 Dec 2001 22:13:01 -0800, mark_brehmen_at_yahoo.com (mark) wrote:
>
> >I have an sql script something like
> >
> >select * from emp where hire_date
> >>>TO_DATE(&&PARAM_DATE,'DD-MON-YYYY')
> >
> >PARAM_DATE is the parameter i pass to the sql script.
> >
> >I call the sql script from SQLPLUS. But when i execute it, i get
> >"invalid column name". It becomes hire_date >> 1-JAN-2001
> >
> >How do i insert the escape characters?
>
> TO_DATE('&&PARAM_DATE','DD-MON-YYYY')
>
> Note the difference
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Dec 25 2001 - 03:44:30 CST
