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

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

Can you try going to ORACLE.com?
A brief vist there will eventually get you to this description: "PL/SQL is Oracle's procedural extension to industry-standard SQL. PL/ SQL naturally, efficiently, and safely extends SQL. Its primary strength is in providing a server-side, stored procedural language that is easy-to-use, seamless with SQL, robust, portable, and secure. Thus, it offers a platform for robust, high-performing enterprise applications, not only for our Fortune 500 customers, but also for Oracle Applications, which have over 4 million lines of code. (Serverside  PL/SQL needs no explicit installation or licensing. It is an implicit part of the Oracle Database and is documented as such.)"

Note the last sentence in particular. It is a DBMS Server programming language. IOW a back end language, not a user interface language.

Finding that quote took three clicks from ORACLE's home page. left menu - DEveloper Tools
main frame DATABASE & PL/SQL bullet item main frame the PL/SQL bullet item

Ed Received on Sun Feb 18 2007 - 13:43:43 CST