Re: display a boolean variable?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 10 Jul 2007 15:28:02 -0700
Message-ID: <1184106480.690846@bubbleator.drizzle.com>

Maxim Demenko wrote:
> DA Morgan schrieb:

>> jobs wrote:
>>> How can I display a Boolean Variable?
>>>
>>> to_char?
>>> cast?
>>>
>>> I'm trying to do this:
>>>
>>> dbms_output.put_line(booleanvariable);
>>>
>>> getting error :  wrong type of arguments in put_line
>>>
>>> Thanks for any help or information.
>>
>> DECODE(x, TRUE, 'TRUE','FALSE')

>
> If this is not a pseudo code, i'm not quite sure, it can work.
> To OP:
> look at sys.diutil.bool_to_int() function
>
> Best regards
>
> Maxim

It was intended a pseudocode as you DECODE can not handle booleans.

I should have used IF/ELSE.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jul 10 2007 - 17:28:02 CDT