There is a free version of TOAD at www.toadsoft.com. Not up-to-date, but
free.
"vlad" <bulk_at_sfatcu.com> wrote in message
news:YXPV9.19650$kH3.3130_at_sccrnsc03...
> 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 - 08:22:28 CST
