Re: SQL Plus

You can try

set numwidth 15

I don't know if this is what you are looking for.

Thanks
Venkat

In article <37CD564A.9D537E3D_at_england.com>,   Y <yunus000_at_england.com> wrote:
>
>
> Jill wrote:
> >
> > Is there anyway to do this globally? We have a table with about 40
or 50
> > columns, and I just want to select * from it.
> >
>
> You really want blood don't you Jill baby.
>
> You cannot do it globally.
>
> try creating a spoolfile:
>
> select 'col ' || column_name ||' format a25'
> from all_tab_columns
> where table_name = upper('&table_name');
>
> then run your edited spool file in your sql session.
>
> Hope this helps.
>
> --
> -------------------------------------------------------------
> "Don't be suckered in by the comments - debug only the code."
> To reply by e-mail remove '000' from my address
> -------------------------------------------------------------
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 01 1999 - 14:45:49 CDT