Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simply viewing data in a database
Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<MPG.1966021e2f473f3b9897d9_at_news.la.sbcglobal.net>...
> Stephen_CA was kind enough to write:
> > Hi,
> >
> > I agree with Sybrand on this one..every couple of months someone
> > troops over with a new GUI tool for me to try.Invariably, I find
> > myself back using SQL*Plus
> > in no time. The problem is, if you never learn SQL and
> > perform all your operations by clicking or "dragging and dropping" you
> > become very product specific. If you switch jobs and they don't use
> > that product you find yourself standing there like a deer in
> > headlights..
> >
> > My two cents,
> >
> > Steve
> >
> >
> >
> >
> > hay_tray_at_yahoo.fr (philippe) wrote in message news:<d6b0dfa5.0306270302.78b91eb3_at_posting.google.com>...
> > > You can use a lot of Tools From Tools provided by Oracle to very
> > > expensive tools but very good too.
> > >
> > > I suggest you this one which is free and don't need to know SQL,
> > >
> > > But knowing SQL is a good thing for the future.
> > >
> > > Find "Oracle Tool" at http://membres.lycos.fr/pmscontact/
> > > or on
> > > simtel.com
> > > orafaq.com
> > >
> > > regards
> >
>
> And I'll add another two cents to the pot:
>
> I don't use a GUI sql tool because it keeps me from knowing sql. I use
> them because the output is much more readable in a spreadsheet format
> than the wrapping that sqlplus does if you're not careful with the
> formatting.
>
> As a matter of fact, both of the gui tools I use (toad and benthic)
> require that I type sql statements exactly the same way I do in a
> command-line sqlplus. Well, okay, in the gui tools, some people can
> double-click a SELECT from a list, double-click one or more column names
> from another list, etc to build their sql statement ... but I find it
> much quicker to just type the darn thing. I guess the GUI helps those
> who still type with two fingers ... or those who have to deal with
> databases where the designer made every table and column name 30 chars.
I agree that SQL*Plus can be a real pain with wrapping its format in
general
..and I also use TOAD when I want to view data or metadata..I wouldn't
recommend using SQL*Plus exclusively !
Received on Wed Jul 02 2003 - 13:23:17 CDT
![]() |
![]() |