Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there a "GO" statement for Oracle
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 ...;
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