Re: display a boolean variable?

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')

-- 
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