Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Decode and Empty Columns
One thing that you can do is
decode( rtrim( col1|col1, '', NULL, col1|col2|col3 )
On Sun, 31 Aug 1997 18:44:39 +0200, Dietrich Mueller <dmueller_at_mail.oec.uni-osnabrueck.de> wrote:
>Hi everyone,
>I need some help regarding Decode and empty rows in a select -statement.
>where pasting columns together.
>Basically I do the following:
>
>Select col1, Decode(col1||col2,<empty>,NULL, col1||col2||col3)
>from <table> ...
>
>How can i test if co1||col2 are <empty> i.e only contain spaces?
> Types of col1-col3 are char.
>
>Thanks a lot
>
Received on Tue Sep 02 1997 - 00:00:00 CDT