Re: [newbie] pl/sql goals

From: Mark Bole <makbo_at_pacbell.net>
Date: Fri, 27 Aug 2004 22:51:55 GMT
Message-ID: <fWOXc.13098$fz1.908@newssvr29.news.prodigy.com>

Hans Forbrich wrote:

> Daniel Dupont wrote:
>
>

>>Hi,
>>can I have a short description of pl/sql, including its main goal ?
>>regards,
>>D

>
>
> Following is _my_ interpretation, not Oracle's.
>
> PL/SQL is a procedural programing language, based on Ada. It is p-compiled
> and run using a PL/SQL engine which is frequently (usually?) invoked in the
> Oracle RDBMS memory space to provide secure(1) procedural capabilities
> which can efficiently interact with, and even extend, traditional
> transactional SQL.
>

[...]
>
> Now - go and read the docco to understand what this means <g>
> /Hans

And, as of 9i, it's starting to catch up with Perl! ;-)

• Multilevel Collections "You can model complex data structures such as multidimensional

         arrays in a natural way."

• Associative arrays: "You can create collections that are indexed by VARCHAR2 values,

        providing features similar to hash tables in Perl and other

        languages."

--Mark Bole Received on Fri Aug 27 2004 - 17:51:55 CDT