Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: User defined function acting as a built-in function

Re: User defined function acting as a built-in function

From: Mladen Gogala <gogi_at_ASTER.SI>
Date: Wed, 3 Jan 1996 09:21:44 +0100
Message-Id: <9601031110.AA04881@alice.jcc.com>


Hi!
On Jan 2, 5:20pm, Subramaniam, Sridhar wrote:
> Subject: Re: User defined function acting as a built-in function
> You need to be running O7.1.x + version of Oracle to be able to do this.
>
> Sridhar Subramaniam
> Telstra Corporation
> Sydney - Australia
> Email : ssubrama_at_nibucorp.ccdn.otc.com.au
> avion_at_ozemail.com.au
> ----------
> From: owner-oracle-l
> To: Multiple recipients of list ORACLE-L
> Subject: User defined function acting as a built-in function
> Date: Sunday, 31 December 1995 4/28PM
>
> Hi folks,
>
> Is there a way to write an user defined stored function in Oracle
> which can act as a built-in function, that is, can be used in Select clause
> of an SQL statement.
> Any suggestion will be appreciated.
> TIA
>
> _______________________________________________________________
> Bharat Bhushan Tripathi
> Senior Software Engineer Ph. (011-8)-562585, 562588-92
> Tata Unisys Limited, Fax. (011-8)-56584
> Computer Consultancy Division, Tlx. 08905-211 TULN IN
> SDF#A/5-A/6,
> Noida Export Processing Zone, Noida - 201 305 INDIA
> E-Mail. bbt_at_celtics.tulnepz.unisys.com
> _______________________________________________________________
>-- End of excerpt from Subramaniam, Sridhar

This is the fanciest new feature of version 7.1. This feature is well documented in version 7.2 manuals.
Hope it helps!

--
Mladen Gogala
ASTER Ljubljana

Tel  : ++386 61 1683-511                 Snail-mail:
FAX  : ++386 61 1683-165                 ASTER Ljubljana
Email: gogi_at_aster.si                     Nade Ovcakove 1
WWW  : www.aster.si                      61000 Ljubljana
                                         Slovenia
All opinions are my own,not of my employer. Received on Wed Jan 03 1996 - 06:11:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US