Re: User-defined functions supported?

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/03/01
Message-ID: <3317940e.2651482@nntp.mediasoft.net>#1/1

On Sat, 01 Mar 1997 12:01:57 +1100, Simon Harris <simon_at_addease.com.au> wrote:

>This is a multi-part message in MIME format.
>------------3B3238C2225C1
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain; charset=us-ascii
>
> I'm currently implementing a system that makes use of user-defined
>functions in Sybase SQL Anywhere. Are user-defined functions suported in
>other DBMS such as Sybas System 11 and Oracle etc?
>

In Oracle, yes. You can write functions in pl/sql and then call them from sql. for example:

create function myfunc( x in varchar ) return number as
begin

    ....
end;

select myfunc( c ) from T
/

>Regards, Simon.
>
>------------3B3238C2225C1
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Simon Harris
>Content-Disposition: attachment; filename="nsmailP8.TMP"
>Content-Type: text/x-vcard; charset=us-ascii; name="nsmailP8.TMP"
>
>BEGIN:VCARD
>FN:Simon Harris
>N:Harris;Simon
>ORG:Addease Pty. Ltd.
>ADR:;;P.O. Box 1484;COLLINGWOOD;VIC;3066
>EMAIL;INTERNET:simon_at_addease.com.au
>TEL;WORK:+61 3 9416 2944
>TEL;FAX:+61 3 9416 2580
>X-MOZILLA-HTML:T
>END:VCARD
>
>
>------------3B3238C2225C1--
>

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Sat Mar 01 1997 - 00:00:00 CST