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

Home -> Community -> Usenet -> c.d.o.server -> Re: Does PL-SQL exist only for Oracle or for other database products as well ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Feb 2007 11:52:26 -0800
Message-ID: <1171828346.814082.34230@k78g2000cwa.googlegroups.com>

On Feb 18, 4:43 am, 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

Procedural Language SQL is an Oracle product that Oracle has not ported to work with other databases. Oracle did propose PL/SQL to the ANSI committee as a database standard but I do not think the proposal went anywhere.

DB2 has SQL-PL, but the syntax and statements are very different from Oracle's PL/SQL

SQL Server has T-SQL which is still fairly close to the original Sybase version that it came from but again is very different from Oracle's PL/SQL

HTH -- Mark D Powell -- Received on Sun Feb 18 2007 - 13:52:26 CST