database Oracle 的免费桌面客户端?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/820077/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Free desktop client for Oracle?
提问by pugmarx
Which is the best Open Sourcefree 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.
哪个最好 开源用于查询 Oracle 数据库的免费客户端?它可能还支持其他数据库(MySQL、Postgres 等),因为我们的开发环境经常需要在不同数据库之间切换。
回答by Peter Perhá?
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.
我一直在使用 Oracle SQL Developer(因为它是免费的),起初我讨厌用它度过的每一分钟。我的图形仍然有奇怪的问题,因为它在 Vista 上运行,并且似乎存在某种图形驱动程序问题(幸运的是,没有人可以让它在 Vista 上正常运行,所以我并不孤单),使得它的使用相当麻烦。
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.
尽管如此,我必须学习如何处理它,现在我必须承认它是一个用于查询 Oracle 数据库的简洁且非常有用的工具(不仅仅是)。我想你也可以从中查询其他数据库,例如我用它来查询一些旧的 MS Access DB,所以我相信你也可以查询 SQL Server。
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 :)
您可以进行数据迁移、导入/导出、查看 OWA 输出,据称还可以进行调试(单步执行、设置断点等)PL/SQL 代码,但我还没有尝试过。到目前为止,我对 sqlplus 命令行一直很好:) 尝试一下,不要让与 Vista 相关的图形问题给您留下错误的印象:)
回答by Ryan Thames
If by open-source you really mean free, then Oracle SQL Developeris free. However it is not open-source. It is fully supported though, we use it where I work all the time.
如果您所说的开源确实是免费的,那么Oracle SQL Developer是免费的。但是它不是开源的。虽然它得到了完全支持,但我们一直在我工作的地方使用它。
If you're interested you can go herefor a good starting reference on its features.
如果您有兴趣,可以到这里获取有关其功能的良好入门参考。
回答by pencilslate
SQLTools is free and clean light weight client. www.sqltools.net
SQLTools 是免费且干净的轻量级客户端。 www.sqltools.net
回答by Matthew Watson
What kind of "client" do you mean? Do you mean the actual drivers, or just an application you can get SQL results from? eg, SQuirrel SQL
你是指什么样的“客户”?您是指实际的驱动程序,还是只是可以从中获取 SQL 结果的应用程序?例如,SQuirrel SQL
回答by Stephen ODonnell
Well Oracle provide SQL Developer for free, which is basically an Oracle IDE - lets you browse tables, code editor for PLSQL, SQL query window etc ...
好吧,Oracle 免费提供 SQL Developer,它基本上是一个 Oracle IDE - 让您浏览表、PLSQL 的代码编辑器、SQL 查询窗口等......
回答by Karthik
If you use a mac, You can try macsequel - a native mac client for oracle.
如果您使用 mac,您可以尝试macsequel - oracle 的本机 mac 客户端。
回答by Matthew Flaschen
One answer (for any platform and database) is just use ODBC. E.g. on POSIX, unixODBC. Oracle of course supports the standard with their own drivers.
一个答案(对于任何平台和数据库)就是使用 ODBC。例如在 POSIX、unixODBC 上。Oracle当然用自己的驱动程序支持标准。