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