Re: How to use user function in SELECT query

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 03 May 2006 12:23:43 +0200
Message-ID: <445885c6$0$4516$9b4e6d93@newsread2.arcor-online.net>

Procrastinator schrieb:
> 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;
>

But this does:
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; bignum := sqr(3);

end;

Best regards

Maxim Received on Wed May 03 2006 - 05:23:43 CDT