Re: Simply viewing data in a database

"Stephen_CA" <stephen.bell_at_sympatico.ca> wrote in message news:5aeee507.0306270607.911de49_at_posting.google.com...
> 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

First of all Golden is available since 1997. And it was there when there was no free TOAD, but only the full blown version at 3000$ or so. Second, you don't drag or drop anything, at most you scroll through records or export a query result to a file.
Third, you can copy query results to the clipboard, which allows you to easily paste them into another document in a matter of seconds.

Of course you could do the same by writing a script creating a CSV file and import it into the same document, but I bet it will take more than 2 seconds. Instead of writing "select * from table;", you must write "select col1 || ',' || col2 ... etc, etc", what a clever way of spending your time, isn'it?
Ok, you come up with a script that takes the name of the table and returns a string containing the select statement, then you copy it to the command line and there you go. And then?
Then a smartass shows up and says:
 "hey, this way you never learn how to manually write CSV files!"

Cheers,
Flavio Received on Fri Jun 27 2003 - 10:50:02 CDT