Re: spool command doesn't work

From: Joachim Pense <joachim.pense_at_t-online.de>
Date: Thu, 7 Jun 2001 20:38:18 +0200
Message-ID: <9fohmt$qgh$03$1@news.t-online.com>

Gary Dickinson wrote:

>
> spool data
> select to_char(strikedate,'yyyy/mm/dd hh24:mi'),
> latitude, longitude,amplitude
> from ltng_strikes
> where latitude between '&SouthLatitude' and '&NorthLatitude'
> and longitude between '&WestLongitude' and '&EastLongitude'
> and strikedate between
> to_date('&startdate 00:00', 'yyyy/mm/dd hh24:mi')
> and to_date('&enddate 23:59', 'yyyy/mm/dd hh24:mi')
> spool off
> /
>

Put the "/" line after the sql statement, which is before the "spool off" sqlplus statement

Joachim Received on Thu Jun 07 2001 - 13:38:18 CDT