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: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Mon, 19 Feb 2007 10:27:31 +1100
Message-ID: <MPG.20438bec6bd0c9c59898e2@news.readfreenews.net>

peter.swam_at_yahoo.com says...
> Sorry for this newbie question: But is PL-SQL a special Oracle script language or does it exist
> for other database products as well ?

To all intensive purposes, PL/SQL is Oracle proprietary.

The "equivalent" in MS-SQL is known as T-SQL. For DB2 it is SQL PL. Sybase is Transact-SQL?

For MySQL, stored procedures only came in from v.5, and I don't think its language syntax has a name.

How closely they look like each other depends on their compliance with and extension from the ANSI SQL:2003 standard.

Geoff M Received on Sun Feb 18 2007 - 17:27:31 CST