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

Home -> Community -> Usenet -> c.d.o.misc -> Re: display a boolean variable?

Re: display a boolean variable?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 11 Jul 2007 00:07:18 +0200
Message-ID: <46940316.9000704@gmail.com>


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 Received on Tue Jul 10 2007 - 17:07:18 CDT

Original text of this message

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