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