Re: Input in SQL+

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 6 Jun 2001 23:40:53 +0200
Message-ID: <tht8n2ljtenf73@beta-news.demon.nl>

"Gary Dickinson" <gd_at_interchange.ubc.ca> wrote in message news:9fm7f4$gnm$1_at_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
>
>

Refer to
define
and
accept
in the sql*plus reference manual.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Jun 06 2001 - 16:40:53 CDT