how to put multiple select in a run.sql file?

From: <newsman_at_noone.C0M>
Date: Fri, 30 Aug 2002 21:34:10 GMT
Message-ID: <16899228.svlJond9u2_at_heron>


I know very little about sql/oracle I just need to verify a few things in a db.

I want to run it thru an sql file

sqlplus user/user_at_dbRacedat < run.sql

but when I put multiple select into the run.sql I get an error:
ORA-00933: SQL command not properly ended

set pau off
set spool "bestlap.txt"
select * from table;
select laptime from table where laptime like 'best'; Received on Fri Aug 30 2002 - 23:34:10 CEST

Original text of this message