Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fresher DBA!!!
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 GermanyReceived on Mon Feb 27 2006 - 06:38:48 CST