Re: output format in SQL*Plus!!!??

In article <94sn3i$cd8$1_at_nnrp1.deja.com>,   ibm_97_at_yahoo.com wrote:
> 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/
>

You might try looking into the SQLPlus set command.

I believe changing FEEDBACK to 0 would remove the message.

FEEDBACK, HEADING, PAGESIZE, TERMOUT, PAUSE, VERIFY in various combinations can make the output look different. Look into changing them.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/