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: Gert van der Kooij <gert_at_invalid.nl>
Date: Mon, 27 Feb 2006 13:30:12 +0100
Message-ID: <MPG.1e6d0f3b1f83b705989949@news.xs4all.nl>


In article <1141041412.528642.261910_at_t39g2000cwt.googlegroups.com>, (bikkaran_at_in.ibm.com) says...
> Hi ,
>
> As far as PLSQL is considered Db2 has its own set of structural
> Prograaming . It is referred to as SQL PL in DB2 .
> The fundamentals are same whethere its DB2 or Oracle. I had a 2 yr
> of exposure in PLSQl of Oracle , and suddenly when I joined IBM I
> was put into DB2 .. Though initially it was very difficult now i am
> quiet comfortable.
>
> PL?SQL or SQL PL ....is basically used for server side programming
> and that exists for both DB2 as well as Oracle or for that matter any
> database.
>
> Regards
>
>

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. Received on Mon Feb 27 2006 - 06:30:12 CST

Original text of this message

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