sqlserver!=Oracle.
Seperate the commands with a ;
just run them sequentially. In sqlplus just run them sequentially seperated
by a ;
Jim
"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 Tue Feb 11 2003 - 21:07:54 CST
