How to use user function in SELECT query

From: Procrastinator <ali711_at_sunnipath.com>
Date: 3 May 2006 02:56:18 -0700
Message-ID: <1146650178.715782.263470@e56g2000cwe.googlegroups.com>

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; Received on Wed May 03 2006 - 04:56:18 CDT