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 -> Date Parameter in Sql scripts help needed

Date Parameter in Sql scripts help needed

From: mark <mark_brehmen_at_yahoo.com>
Date: 23 Dec 2001 22:13:01 -0800
Message-ID: <fa4781e4.0112232213.7498cf8d@posting.google.com>


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? Received on Mon Dec 24 2001 - 00:13:01 CST

Original text of this message

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