Re: how to put multiple select in a run.sql file?
From: <newsman_at_noone.C0M>
Date: Mon, 02 Sep 2002 21:40:13 GMT
Message-ID: <2998298.unhak6U4dD_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 Mon Sep 02 2002 - 23:40:13 CEST
Date: Mon, 02 Sep 2002 21:40:13 GMT
Message-ID: <2998298.unhak6U4dD_at_heron>
Alex Ivascu wrote:
> You have to use the '/' instead of the ';' in your script file.
I'll give that a try. BTW I looked high-and-low to find this answer before posting but couldn't find anything about it. I even perused some sql scripts I found and still couldn't deduce that a '/' was needed. Maybe I just missed it...but it seems like this is one of the little details that is assumed people know.
> > 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 Mon Sep 02 2002 - 23:40:13 CEST