Re: Setting for default column width?

Damn it, I knew this would happen. I bring up a purely technical question, mention a Microsoft tool, and argument ends in "MS is a monopoly". With all due respect, Daniel, I am completely befuddled at your connection between column formatting and "MS monopoly". Also, I fail to see what platform-independence has got to do with this. Are you implying a trim function doesn't exist in C on Unix machines?

SQL*Plus has some cool column formatting that can be done on a specific column. Query Analyzer can specify column cut-off for all columns. Just formatting options, pure and simple. Oracle's SQL*Plus doesn't have default cut-off formatting. No biggie.

About the tools you mentioned. I did download the TOAD evaluation. It's nice, but damn, it's expensive. Close to $1000, if I remember correctly. I'll check on SQL Navigator.

vlad

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E27AA9B.25C48BF7_at_exesolutions.com...
> 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 - 03:23:04 CST