Re: Does ORACLE allows to define USER-DEFINE DATA TYPE like in SYBASE??

In article <TRUONG.96Jan31114348_at_vanbig.van.oz.au>, Truong Phan <truong_at_van.oz.au> writes
>
>Hi all,
>
>I am new in ORACLE's world!
>
>Does ORACLE allows to define USER-DEFINE DATA TYPE or STORED PROCEDURE.
>
>Where could I find a FAQ for ORACLE?
>

I'm not sure about the user defined data types, they are possibly on their way with Oracle 8, however Oracle has far superior Stored Package, Procedure, Function & Trigger capabilites.

For example it is possible to create a function which may be embedded in a select list:

     SELECT TCOL1, TCOL2,  My_Function(Par1, Par2,,,)
        FROM .....

Packages allow procedures to be logically grouped together and stored in the database. When a packaged procedure is invoked the whole package is cached ready for the next function/procedure call. Global variables may be defined within the package (very usefull at times!).

Clive Bostock Received on Sat Feb 03 1996 - 00:00:00 CET