Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

Learning Oracle Expand / Collapse
Author
Message
Posted Friday, February 8, 2013 11:47 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:28 PM
Points: 4,098, Visits: 9,188
PaulB-TheOneAndOnly (2/8/2013)
nick.mcdermaid (9/20/2012)
In Oracle, client tools are painful. You need to buy TOAD for a GUI, and has some good features (CTRL-Clkick to get table info) but it's basically a dogs breakfast.


SQL Developer is a free GUI by Oracle that pretty much does all that is needed - also, web based OEM is pretty good and offers stuff I have not seen in any other GUI like the capabiltiy to run and check AWR reports, real time tracing, etc.
TOAD is pretty bad at closing connections, I know production environments where it has been banned.
If looking for a third party GUI I would go with DBArtisan.

Oracle SQL Developer is an OK tool, and it can even support connections to a few other database engines like SQL Server, MySQL, and MS-Access. However, it's not as polished as SQL Server Management Studio. SQL Developer is written in Java, which I guess is a plus for some people who develope across different client platforms, but like most all Java apps I've found the tool to be sluggish and occasionally hang.



"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Post #1417856
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse