Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting for default column width?
Found this setting to set all number column formatting:
SET NUMF 999,999.
Now if I only had this setting to set all character column formatting:
SET CHARF A20
vlad
"vlad" <bulk_at_sfatcu.com> wrote in message
news:wANV9.17741$kH3.2941_at_sccrnsc03...
> Hello. Is there in Oracle's tool SQL*Plus a setting that sets all columns
to
> be by default no more than a certain number of characters long? I am aware
> of the COLUMN command, but that doesn't work very well for me, since it
has
> to be specified for each column of a query. It's really bugging me, 'cause
> this feature is available in Microsoft's Query Analyzer and it really
helps
> to quickly take a look at a table's data without reading through
unreadable
> wraps.
>
> More explicitly, I would like something that could do this for every
column
> of every result set returned by SQL*Plus:
> COLUMN COUNTRY_NAME FORMAT A10
>
> Now select data cut off at 10th character, with no wrapping:
> SET WRAP OFF
> SELECT * FROM HR.COUNTRIES;
>
> Looking at the first 10 characters of each column would give me a good
idea
> of the data in that row.
>
> vlad
>
>
Received on Mon Jan 27 2003 - 02:51:59 CST