Input in SQL+

From: Gary Dickinson <gd_at_interchange.ubc.ca>
Date: Wed, 6 Jun 2001 14:33:05 -0700
Message-ID: <9fm7f4$gnm$1@nntp.itservices.ubc.ca>

Hi. I was wondering if anyone knows how to input values in an SQL script. Here's some code I have.

select to_char(strikedate,'yyyy/mm/dd hh24:mi'), latitude, longitude,amplitude
from ltng_strikes
where latitude between 50.41(x) and 50.45(y) and longitude between -119.25(a) and -119.19(b) and strikedate between
to_date('1998/05/01(n) 00:00', 'yyyy/mm/dd hh24:mi') and to_date('2000/09/30(m) 23:59', 'yyyy/mm/dd hh24:mi') /

I would like to let the user be able to input the values marked (x),(y), (a),(b), (n),(m). How can I do this? Any help would be greatly appreciated.

Thanks

Gary Received on Wed Jun 06 2001 - 16:33:05 CDT