Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date Parameter in Sql scripts help needed
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 Mon Dec 24 2001 - 02:11:35 CST