Re: How do oracle programmers send batches of SQL from inside a program?
From: Mladen Gogala <no_at_email.here.invalid>
Date: Fri, 19 Mar 2010 20:42:40 +0000 (UTC)
Message-ID: <pan.2010.03.19.20.42.40_at_email.here.invalid>
On Fri, 19 Mar 2010 13:34:50 -0700, Thomas Gagne wrote:
Date: Fri, 19 Mar 2010 20:42:40 +0000 (UTC)
Message-ID: <pan.2010.03.19.20.42.40_at_email.here.invalid>
On Fri, 19 Mar 2010 13:34:50 -0700, Thomas Gagne wrote:
> If inside a program I want to send multiple SQL statements inside a
> single batch, how is this done inside a program?
That is done using PL/SQL. Essentially, you put a bunch of commands between "BEGIN" and "END" program delimiters.
.....
> I've tried using semicolons and forward slashes, but no luck.
Thomas, you should really get yourself a PL/SQL book by Steve Feuerstein. This book is not a replacement for reading manuals.
-- http://mgogala.byethost5.comReceived on Fri Mar 19 2010 - 15:42:40 CDT