Oracle的免费桌面客户端?[英] Free desktop client for Oracle?

本文是小编为大家收集整理的关于Oracle的免费桌面客户端?的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

哪个是最佳的开源免费查询Oracle数据库的客户端? 它可能还支持其他数据库(MySQL,Postgres等),因为我们的开发环境通常需要在不同的数据库之间切换.

推荐答案

我一直在使用Oracle SQL开发人员(因为它是免费的),并且最初是讨厌每分钟花的时间.我仍然在图形上遇到奇怪的问题,因为它在Vista上运行,并且似乎存在某种图形驱动程序问题(幸运的是,没有人可以在Vista上正确运行它,所以我并不孤单)使它的使用非常繁琐.

尽管如此,我不得不学习如何应对它,现在我必须承认它是一个整洁且非常有用的工具(不仅是)来查询Oracle数据库.我想您也可以从中查询其他DB,例如,我已经使用它来查询一些旧版MS Access DBS,因此我相信您也可以查询SQL Server.

您可以进行数据迁移,导入/导出,请参阅OWA输出,并据称还要调试(逐步浏览,设置断点等...)PL/SQL代码,但我没有尝试过.到目前为止,我对sqlplus命令行都很好:)尝试一下,不要让远景相关的图形问题给您错误的印象:)

其他推荐答案

SQLTools是免费的,清​​洁轻巧的客户. www.sqltools.net

其他推荐答案

如果您是免费的,那么您的意思是免费的,那么 Oracle SQL开发人员是免费的.但是它不是开源的.不过,它得到了充分的支持,我们一直使用它.

如果您有兴趣,可以在这里有关其功能的良好启动参考.

本文地址:https://www.itbaoku.cn/post/597700.html

问题描述

Which is the best Open Source free client for querying an Oracle database? It may additionally support other databases (MySQL, Postgres etc), since our development environment often requires switching between different databases.

推荐答案

I have been using the Oracle SQL Developer (because it's free) and at first hated every minute spent with it. I am still having weird problems with graphics, as it's running on Vista and there seems to be some sort of graphics driver problem (luckily, no-one can get it to run properly on Vista, so I am not alone in this), which makes its use quite cumbersome.

Nevertheless I had to learn how to cope with it and now I must admit it's a neat and very useful tool (NOT ONLY) for querying an Oracle database. I suppose you could query other DBs from it as well, for instance I have used it to query some legacy MS Access DBs, and so I believe you could query SQL Server as well.

You can do data migrations, imports/exports, see OWA output, and allegedly also DEBUG (step through, set breakpoints, etc...) PL/SQL code, but I haven't tried this. I have been fine with sqlplus command-line so far :) Do give it a try, and don't let the Vista-related graphics problems give you a wrong impression :)

其他推荐答案

SQLTools is free and clean light weight client. www.sqltools.net

其他推荐答案

If by open-source you really mean free, then Oracle SQL Developer is free. However it is not open-source. It is fully supported though, we use it where I work all the time.

If you're interested you can go here for a good starting reference on its features.