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>
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