Oracle-L: RE: Oracle 10

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Mon, 05 May 2003 14:27:09 -0800
Message-ID: <F001.005905FA.20030505142709@fatcity.com>

Isn't it funny how different people react differently to different tools? I think SQL Nav has some decent features but I HATE the query interface in SQL Nav... I guess this is why there are so many software companies out there...

:-)

Tim

-----Original Message-----
Sent: Monday, May 05, 2003 6:07 PM
To: Multiple recipients of list ORACLE-L

I hate having to use more than one tool for the same function. After being a SQL*PLUS, ksh command-line die-hard someone last year introduced me to Quests - SQL*Navigator. I like it.

-Interfaces with versioning tools so can version DDL and stored process easily
-Has its own team coding options for check-in/check-out -Automates the formatting of PL/SQL so code is written in a standard fashion so everyone can read eachother's

-Explain plan option and debugging built in. 
-It is about $2,000 but I think worth the cost. 
-Can save SQL as scripts - not exactly history but this tool might even have

it I haven't seen it yet.
-Can look at the database from a DBA-perspective pretty simply -Can compare objects to other objects and just see the differences easily

Oracle OCP DBA

-----Original Message-----
]
Sent: Monday, May 05, 2003 5:32 PM
To: Multiple recipients of list ORACLE-L

> Try Golden from www.benthicsoftware.com

I have golden and its ok for some things (exporting) and outputting in a grid format
It dosnt have a command history (to me tabs are not history) Also, Golden dosnt provide feedback Im accustomed to

Eg
Commit complete
Transaction set
Rollback complete

Also I don't like the rows updated is in a small corner of the lower right portion of the screen.
I emailed the author and he diddnt seem interested in my suggestions....

Golden is fine for the price and what it does, but I cant use it all the time. For day to day use I use sqlplusw and a good (syntax highlighting) text editor.

http://www.editpadpro.com/ <http://www.editpadpro.com/>

bob
>
> Simple fast query tool... Tabs across the top... Favorites
> menu for your scripts... It handles most SQL*Plus
> commands... You can try it for free... $35 bucks to buy
> (less in quantity)... If want a simple, fast query tool and
> Golden is it... I tried it about two years ago and I've been
> addicted ever since...
>
> And before you ask, I'm just a regular joe with no connection
> to these guys... I just like the tool...
>
> Tim
>
> -----Original Message-----
> Sent: Monday, May 05, 2003 4:07 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> >
> > A history editor in sqlplus capable of holding more than the
> > just the last command would be waaay cool.
> >
>
> Yea, yea... <salivating>
>
> One question though,how would you "build your character" if
> your editor
> could buffer more than 1 command??
>
> ;-)
>
> I recall 8.0 has a nice sqlplus worksheet... That was nice much better
> than the new worksheet (which I don't use)I could never get it to work
> on versions >8.0
>
> bob
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
> --
> Author: Bob Metelsky
> INET: bmetelsky_at_cps92.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
> --
> Author: Johnston, Tim
> INET: TJohnston_at_quallaby.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>  
-- 
Author: Bob Metelsky 
  INET: bmetelsky_at_cps92.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>  
San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Johnston, Tim
  INET: TJohnston_at_quallaby.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon May 05 2003 - 17:27:09 CDT