Re: query tool?

Jonathan,

Try the SQL*Worksheet (now called SQL*Plus worksheet) in the Enterprise Manager. As long as you don't use it for production purposes, you can probably get a trial license.

It has history, spooling, and the result sets scroll out in even lines! Amazing but true.

Sql*plus is antiquated. It does take a touch of expertise to make it work the way you want it to work. You will also find it is your best tool when you become an experienced, hard-core DBA and you get away from those touchy-feely graphical tools. Am I showing my age?

;)

Really, there is no better way to become an Oracle expert than to force yourself to use sql*plus. You really have to learn the internals of Oracle to be able to function with sql*plus.

hth,

Jack
Senior DBA @ http://www.xol.com

"Jonathan Crabtree" <crabtree_at_pcbi.upenn.edu> wrote in message news:3A54D1D2.FBC0066A_at_pcbi.upenn.edu...
> I work in the Center for Bioinformatics at the Univ. of Penn. We
> recently migrated our database from Sybase to Oracle (Sun Solaris OS)
> and need to find a better query tool than sqlplus. We were using data
> work bench and would like to have that sort of functionality,
> specifically result presentation, query history, and ability to save
> results to files. Has anyone had this experience and been able to find a
> good Unix based tool ?
>
> Please either respond to the news group or to pinney_at_pcbi.upenn.edu
>
> Thanks for any help. -DP
>
Received on Thu Jan 04 2001 - 21:27:43 CST