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: SQL-Commands in one big statement

Re: SQL-Commands in one big statement

From: <sybrandb_at_yahoo.com>
Date: 16 Jun 2004 01:45:43 -0700
Message-ID: <a1d154f4.0406160045.47a997fe@posting.google.com>


"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

Original text of this message

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