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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function vs Function()-no input parms-

Re: Function vs Function()-no input parms-

From: Bill Frost <Bill.Frost_at_NOSPAM.hpa.com.au>
Date: Thu, 8 Apr 1999 15:31:08 +1000
Message-ID: <7ehf16$bkn$1@m2.c2.telstra-mm.net.au>


You should do something like this:

function test_func (junk varchar2 default '') return varchar2 is
begin

    return 'test_func was here';
end;



Then, you invoke it with test_func()

:)BF

Richard Elliott <bullseye_at_flash.net> wrote in message news:370BF4E9.12CFDED5_at_flash.net...
> I wrote a function to return a specific table/row/column. It needs no
> input parms. To execute this function I just reference it in the sql
> directly. ie
>
> select get_accounting_date from dual;
>
> The problem, a small but annoying one, is I want it to look like a
> function, ie
> select get_accounting_date() from dual;
>
> The way it is now it looks like a column name, not a function. I have
> tried default null parms but then I am forced to supply a value in the
> reference ie
> select get_accounting_date(' ') from dual.
> There has to be a solution, other functions work the way I would like
> this one to, like sysdate() etc...
> I have quite a few of these and I would really like for the SQL to be
> more readable by using the () with every function.
> I really have tried everything I can think of to get it to work with
> select get_accounting_date().
>
> Thanks in advance for your help.
>
>
Received on Thu Apr 08 1999 - 00:31:08 CDT

Original text of this message

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