开发者

Good Oracle database development and management tool on Windows [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 9 years ago.

Improve this question

I'm looking for an Oracle database management tool like sql se开发者_运维百科rver management studio. I've searched the internet and found a lot of tools on the following link:

http://www.freedownloadscenter.com/Search/oracle.html.

But I don't know which one is better.

I need a stable and easy-to-use GUI tool for working on windows.


The best free ones are (in no particular order)

  • SQL Developer
  • TOra
  • TOAD
  • Oracle Enterprise Manager (parts are included in the licence)
  • Eclipse plugin - SQL Explorer

The best commercial ones are (in no particular order)

  • TOAD
  • DBArtisan
  • Oracle Enterprise Manager
  • PL/SQL Developer


My shop uses an open-source Eclipse plugin called SQL Explorer: http://eclipsesql.sourceforge.net/ It has good stuff for examining schemata; it integrates with your source code control system; it works on other database table servers too.

We also use a commercial tool called PL/SQL Developer: http://www.allroundautomations.com/plsqldev.html This tool has a "SQL Beautifier" which can tidy up some of the hairiest queries you can imagine. In tidying them up, it helps the one writing the query find typos. It also has a context menu that will do "EXPLAIN PLAN" on a query that's already running, and a way to stop a running query. Those are incredibly handy tools.

Carpenteri mentioned Oracle Enterprise Manager. That comes with your Oracle thick client. I find it helpful for getting an instance-wide view of what's going on in your server.


If you are looking for a system management tool for your Oracle database it is worth looking at the Oracle Enterprise Manager


You could use a combination of some tools like SQL Developer, SQLTools and Aqua Data Studio

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜