Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Functions and Boolean datatype

Re: Functions and Boolean datatype

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 8 Sep 1998 00:46:16 GMT
Message-ID: <35f75ac2.39293776@netnews.worldnet.att.net>


On Sun, 6 Sep 1998 22:06:57 -0400, "Gocha Mchedlishvili" <gocham_at_mci2000.com> wrote:

>Is there any way I can pass boolean expressions into custom function and how
>to get this expression in function:

No, I don't believe that you can do this from an SQL statement. You can do it from within PL/SQL code, but that's because BOOLEAN is a valid PL/SQL datatype. SQL doesn't recognize BOOLEAN, so you can't use it in a query.

Jonathan Received on Mon Sep 07 1998 - 19:46:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US