Re: Setting for default column width?

vlad wrote:

> 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

There is no such thing in SQL*Plus nor would it make any sense were it to exist as SQL*Plus is hosted on many platforms and operating systems.

The only reason QA works on Windows platforms is because MS is a monopoly controlling every piece of software.

If you want a GUI tool for Oracle there are dozens of them. And they are Windows-centric and thus will do what you want. The most common ones are TOAD and SQL Navigator by Quest and Oracle provides one as do lots of other companies.

Daniel Morgan Received on Fri Jan 17 2003 - 01:02:51 CST