Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fresher DBA!!!

Re: Fresher DBA!!!

From: Knut Stolze <stolze_at_de.ibm.com>
Date: Mon, 27 Feb 2006 13:38:48 +0100
Message-ID: <dturso$3e4$1@lc03.rz.uni-jena.de>


Gert van der Kooij wrote:

> The big difference is that SQL PL statements can't be run from the
> commandline. They have to be put into a stored procedure or function.
> It would be very nice if SQL PL could be used from within commandline
> scripts.

But you already can do that today:

db2 => begin atomic declare x int; set x = 2; set x = x*x*x; insert into t values (x); end
DB20000I The SQL command completed successfully. db2 => select * from t

A


          8

  1 record(s) selected.

-- 
Knut Stolze
DB2 Information Integration Development
IBM Germany
Received on Mon Feb 27 2006 - 06:38:48 CST

Original text of this message

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