SqlPlus report problem
From: Jaakko Terhonen <Jaakko.Terhonen_at_kolumbus.fi>
Date: Tue, 27 Nov 2001 22:34:49 +0200
Message-ID: <9u0thg$h46$1_at_news.kolumbus.fi>
Date: Tue, 27 Nov 2001 22:34:49 +0200
Message-ID: <9u0thg$h46$1_at_news.kolumbus.fi>
Hi!
I've been trying to create a SqlPlus report with
one 'optional' column which would print on a new line - but only if it is not
NULL.
Something like this:
XXXX XXXX XXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX <- not
null
XXXX XXXX XXX <- null, only
the first row is printed
XXXX XXXX XXX
XXXX XXXX XXX
Problem is that now it prints _two_ blank lines,
no matter whether using any FOLD/NEWLINE/WRAP options!
Is there any way to prevent SqlPlus from printing
a line if the contents of column(s) in that line are NULL ?
Thanks for all responses,
Jaakko
Terhonen
Received on Tue Nov 27 2001 - 21:34:49 CET