Re: Using a variable in the where clause
Date: Sat, 05 Oct 2002 02:01:30 GMT
Message-ID: <_Jrn9.39901$FO4.8324_at_sccrnsc03>
What api?
If it is just in sqlplus then
welect * from atable
where table_date=to_date( '01-OCT-2002'm'dd-mmm-yyyy')
Jim
"Josh" <jr8110_at_yahoo.com> wrote in message
news:a1c10eb3.0210041228.5113f30_at_posting.google.com...
> I'm having a horrible time using Oracle, would anyone be able to tell
> me how i can do a simple select statement such as the following:
>
> ----------
> declare var_date date;
>
> var_date = '01-OCT-2002'
>
> select * from atable
> where table_date = var_date;
> ----------
>
> Thats using pseudo-code
>
> I basically want to select data out of a table and filter the
> resultset based on the var_date variable, which is simply a date
> variable
>
> I'm using Oracle 8.0
>
> Thanks
Received on Sat Oct 05 2002 - 04:01:30 CEST