Re: force a title to print in sqlplus
- From: stephen booth <stephenbooth.uk@xxxxxxxxx>
- To: rgramolini@xxxxxxxxxxxxxxx
- Date: Fri, 13 May 2005 14:45:29 +0100
On 5/13/05, Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
