Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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