Learning Oracle

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Working with Oracle » Learning Oracle

51 posts, Page 6 of 6

«««2 3 4 5 6

Learning Oracle

Rate Topic

Display Mode

Topic Options

Author

Message

Eric M Russell

Posted Friday, February 08, 2013 11:47 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 1,164, Visits: 3,340

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.

"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47

Post #1417856

« Prev Topic | Next Topic »

51 posts, Page 6 of 6

«««2 3 4 5 6

Permissions