Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there a "GO" statement for Oracle

Re: Is there a "GO" statement for Oracle

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 11 Feb 2003 21:47:36 -0800
Message-ID: <3E49DFF8.58B3C320@exesolutions.com>


Mark Kamoski wrote:

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

BEGIN

   insert into ...;
   insert into ...;
   insert into ...;

END;
/

Don't ask about SQL Server commands as the two databases are conceptually and architecturally different. Just describe what you want to do and ask how to do it.

Daniel Morgan Received on Tue Feb 11 2003 - 23:47:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US