Home -> Usenet -> comp.databases.oracle -> Using a variable in the where clause

Using a variable in the where clause

From: Josh <jr8110_at_yahoo.com>
Date: 4 Oct 2002 13:28:05 -0700
Message-ID: <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 Fri Oct 04 2002 - 22:28:05 CEST












Original text of this message