Re: Does PL-SQL exist only for Oracle or for other database products as well ?

On Feb 18, 12:43 pm, peter.s..._at_yahoo.com (Peter Swampton) wrote:
> Sorry for this newbie question: But is PL-SQL a special Oracle script language or does it exist
> for other database products as well ?
>
> Maybe PL-SQL is not an original part of MS-SQL Server resp. MySQL but there
> are 3rd party add-ons for these other products ?
>
> Can someone give me a brief hint about the role of PL-SQL
>
> Peter

PL/SQL is Oracle-specific programming language. Mostly used serverside,  though there are Oracle products that employ it client-side (Oracle Forms, for example.) As far as I know, there are no implementations of PL/SQL for other databases, except PL/pgSQL, which is PL/SQL-compatible language in PostgreSQL (at least they claim it to be, though there are significant differences in features and capabilities beyond basic syntax compatibility.) More information about PL/SQL can be found here:

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

(PL/SQL User's Guide and Reference, Oracle10g Release 2.)

Hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Sun Feb 18 2007 - 04:23:06 CST