Re: display a boolean variable?

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 ); Received on Thu Jul 12 2007 - 03:57:37 CDT