Re: Selecting from fuction

Hi,

Thanks for the hint.

In fact, I have to create a function which would return MULTIPLY rows and I don't have a clue how to declare such a function and how to construct return statement. I saw Forms*5 based on functions and they were returning more then one row.

I appreciate any help.

Thank you, Arthur.

Alan Shein wrote:

> >>
> I know that on Oracle8 I can use select statement to select from objects
>
> like functions. Can I do that on Oracle 7.3.4?
>
> Also, could you give me a simple example of such a function?
>
> <<
>
> Generally, the syntax is:
>
> SELECT function_name (parameter1, parameter2...) FROM DUAL;
>
> You select the function from DUAL and pass it parameters. For example, here
> is the usage syntax for a function I created that returns the number of
> business days between two dates:
>
> SELECT num_business_days ( '01-FEB-99' , '15-FEB-99' ) FROM DUAL;
>
> Or, you can use a built-in function, like sysdate (which takes no
> parameters):
>
> SELECT sysdate FROM DUAL;
Received on Thu Sep 30 1999 - 19:03:39 CDT