Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL-Commands in one big statement
"Tolle Meus" <spamschutz_at_muelltonne.de> wrote in message news:<cansot$4ac$07$1_at_news.t-online.com>...
> Hi,
> I have merged many sql-insert-statements in one big command-statement and
> have sent this big command-statement to a DBMS years ago. (I can't remember
> which DBMS it was - SQL-Server, Informix or Oracle)
>
> So now - I am working on a "Oracle 8.1.7"-version and have tried to repeat
> this. I tried to send many INSERT-Statement separated by an ";"-Sign to
> Oracle via ADO - but it failed to succeed.
>
> My Question:
> Is there a way to send more than only one SQL-command directly to oracle?
>
> Like: "INSERT into Table1 (..);INSERT into Table1 (..);INSERT into Table1
> (..);INSERT into Table1 (..);... "
>
> Thanx in advance
> Tolle
Put them in a begin end; block.
Sybrand Bakker
Senior Oracle DBA
Received on Wed Jun 16 2004 - 03:45:43 CDT