Re: How to use user function in SELECT query

From: gazzag <gareth_at_jamms.org>
Date: 3 May 2006 03:38:51 -0700
Message-ID: <1146652731.152475.130080@e56g2000cwe.googlegroups.com>

Procrastinator wrote:
> This doesn't work
>
> Declare
>
> bignum number ;
>
> function sqr(n number) return number
> is
> begin
> return n * n ;
> end;
> begin
>
> -- dbms_output.put_line(sqr(3));
> select sqr(3) into bignum from dual;
>
> end;

This does:

  1 Declare

  2             bignum number ;
  3             function sqr(n number) return number
  4             is
  5             begin
  6                          return n * n ;
  7             end;
  8  begin
  9     bignum:=sqr(3);
 10     dbms_output.put_line('bignum='||bignum);

 11* end;
SQL> set serveroutput on
SQL> /
bignum=9

PL/SQL procedure successfully completed. Received on Wed May 03 2006 - 05:38:51 CDT