Re: SQL Plus Problems

See the SQL*Plus documentation for the COLUMN command. Do something like:

column employee_name format a20
column salary format 99999

You can widen the display beyond 80 characters with something like: set linesize 160

Also, specify the columns of interest instead of using *. You may also want/need to use the substr() function. Alternatively, a product like Toad may be better for your needs.

"Richard Martes" <rmartes_at_worldnet.att.net> wrote in message news:bvsi5.4128$gW5.230904_at_bgtnsc04-news.ops.worldnet.att.net...
> Currently running 8.1.6 Enterprise Edition Release 2 w/win 2000.
>
> select *
> from emp;
>
> Unable to see output clear because each row becomes more than one. How do
 I
> change settings to make the out put clear. Thanks so much
>
>
Received on Fri Aug 04 2000 - 00:00:00 CEST