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

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

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 Sun Sep 01 2002 - 19:04:47 CEST