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

From: <newsman_at_noone.C0M>
Date: Wed, 04 Sep 2002 15:50:50 GMT
Message-ID: <3025605.HIN5xPXzhW_at_heron>


Alex Ivascu wrote:

> You have to use the '/' instead of the ';' in your script file.

FWIW, this did not work.

> 
> Alex Ivascu
> 
> 
> newsman_at_noone.C0M wrote:

>> 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 Wed Sep 04 2002 - 17:50:50 CEST

Original text of this message