output format in SQL*Plus!!!??

Oracle 8.1.6

Hi, there:

A query like:

select col_a, col_b
from table
where .... ;

col_a is varchar2; col_b is integer. When there's no value for "col_b" meet the "where" clause, Display is
"no rows selected"

How can I make the output like: (I still need the title of these columns, even though return nothing from query)

col_a col_b
------ ----

Thanks a lot!!

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 14:36:02 CST