Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date Parameter in Sql scripts help needed

Re: Date Parameter in Sql scripts help needed

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Mon, 24 Dec 2001 09:11:35 +0100
Message-ID: <rood2usbkb90gf3oicg2kqvg8pi6566cac@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 Mon Dec 24 2001 - 02:11:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US