Re: Is there a "GO" statement for Oracle

The "go" command is not a SQL Server command, it is a ISQL, Query Analyzer, OSQL, or whatever command. The "go" command tells the client, ISQL, Query Analyzer, OSQL, or whatever, to submit a "batch" of commands to SQL Server. Matter of fact, if you write you own client program in VB, C, or whatever and send SQL Server a "go" command, it will barf all over you.

And Oracle, um SqlPlus, does not have an equivalent, because SqlPlus doesn't do command batches. As Dan pointed out, you can do something similar with BEGIN..END (anonymous) blocks. There are a lot of differences between Oracle anonymous blocks and SQL Server command batches, but for simple stuff they close.

"Mark Kamoski" <mkamoski_at_yahoo.com> wrote in message news:450d831f.0302111902.464c7d8_at_posting.google.com...
> Hi.
>
> In SQL Server, I can use a "go" keyword to execute multiple
> statements, as follows.
>
>
> -- ....
>
> insert into Scott.OlympicData
> (PKID, Name, Country, Event, Medal)
> values
> (1001, "Frank", "US", "Mens Down Hill", "Bronze")
> go
>
> insert into Scott.OlympicData
> (PKID, Name, Country, Event, Medal)
> values
> (1002, "Sam", "GB", "Mens Down Hill", null)
> go
>
> -- ....
>
>
> However, in Oracle 9i, to which I am a beginner, the SQL Scratchpad
> does not let me do this.
>
> Any ideas?
>
> Please advise.
>
> (Reply to mkamoski_at_yahoo.com if possible.)
>
> Thank you.
>
> --Mark.
Received on Wed Feb 12 2003 - 08:15:01 CST