Re: How to show result of a function call?

Daniel wrote:

> I'm writing some oracle functions and want to call them and display the
> result.
> Is there an easy way to do this in oracle? Up to this point I've
> written a little pl/sql routine to do it where I declare a bind
> variable, assign it to the function result, and print the variable, but
> would like a simpler way, like a 1-line select statement. Any
> suggestions?
>
> Thanks,
> Daniel
>
> --
> To reply to me directly, please remove "ANTISPAM" from the reply-to
> email address.

Hi Daniel,
Have you tried ...

    SELECT my_function() FROM dual;

HTH,
Avi. Received on Mon Jan 01 2001 - 04:53:14 CST