William Robertson wrote:
> On Jul 10, 11:28 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> 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
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> Or perhaps
>
> dbms_output.put_line
> ( CASE boolvar WHEN TRUE THEN 'TRUE' WHEN FALSE THEN 'FALSE' END );
Or CASE.
--
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 Thu Jul 12 2007 - 10:36:35 CDT