Re: force a title to print in sqlplus

On 5/13/05, Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
> Good morning all,
> One of my developers wants to know if there is a way to force the ttitle =
to
> print on a report even if no rows are found. Does anyone know how to do
> this?

The thing that immediately springs to mind is to add:

union
select ' ' " " from dual

to the end of your queries. This will ensure that you get at least one (blank) row returned.

Stephen

--=20
It's better to ask a silly question than to make a silly assumption.

--
http://www.freelists.org/webpage/oracle-l