If you put the commands in a script file and call them in SQL*PLUS using
@myscript.sql, you can run them all at once. Inside of SQL*PLUS though
there is not a way to run them all at once, that I'm aware of anyway.
Kenny Gump
OCP 7.3 DBA
Larry Coon wrote in message <372E5ECC.38EF_at_home.com>...
>Sorry if this is something obvious. Using
>SQL*PLUS in Win 98 (Version 8.0.5.0.0)
>connecting to Oracle 8. I use this db
>infrequently. Some time ago, I thought I
>was able to string together multiple SQL
>commands by separating commands with a
>line containing a "/". For example:
>
> insert into X values (1, 2, 3)
> /
> insert into X values (4, 5, 6)
> /
> insert into X values (7, 8, 9)
>
>(etc.) Now, it doesn't work -- I get the
>error message "ORA-00933: SQL command not
>properly ended". I've tried everything
>else I can think of also. Any suggestions?
>
>Thanks,
>
>Larry Coon
>University of California
>larry_at_assist.org
>and lmcoon_at_home.com
Received on Tue May 04 1999 - 06:53:25 CDT
