From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.3 required=5.0 tests=BAYES_00,INVALID_MSGID autolearn=no autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,ed70286b8b89ab0d X-Google-Attributes: gid103376,public From: x@x.x (x) Subject: Re: Ada-like language Date: 1999/04/19 Message-ID: #1/1 X-Deja-AN: 468495765 References: <19990417221639.10903.00002108@ng03.aol.com> Organization: Newscene Public Access Usenet News Service (http://www.newscene.com/) Newsgroups: comp.lang.ada Date: 1999-04-19T00:00:00+00:00 List-Id: In article <19990417221639.10903.00002108@ng03.aol.com>, tconiam@aol.com (TConiam) wrote: >>I think Oracle (the DB company) made a language (PSQL?) that is based on >>Ada. I'm not sure though... >> > >Yes, Oracle has PL/SQL which is based on Ada and has SQL like extensions >including facilities to loop on the results of a SELECT as well as all the DDL, >and DML. It even includes exception handling for database events. > >It is used for programming database triggers (event handling) and for general >purpose database scripts. > >I have even written a crude message parser in it. If I could add something to this... PL/SQL does share a lot of syntax with Ada (even packages and block structure), but the similarity ends there. Where Ada is a very strongly typed language, PL/SQL is a (very) weakly typed language. You can assign just about anything to anything else and freely mix and match types in expressions with nary a complaint from the 'compiler'. That has bitten me more times than I care to admit. It's too bad Oracle didn't implement the philosophy of Ada along with the syntax.