This works (kind of).

Select something from dual and then do a noprint on that. Below is a workaround.

ttitle center 'testing'
column x noprint
select 'x' x from dual;

/* Now have the main query */
select * from dept where deptno=77;

Top title will appear even if no rows are selected.


Only problem my second select statement produces a second set of page headings. There has to be a better way.
P


[Edited by mrpaulwass on 06-24-2002 at 11:35 AM]