Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simply viewing data in a database
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.
-- :%s/Karsten Farrell/Oracle DBA/gReceived on Fri Jun 27 2003 - 10:27:04 CDT
![]() |
![]() |