对于 Oracle，是否有 SQL*PLUS 的良好替代品？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/286091/
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
Is there a good alternative to SQL*PLUS for Oracle?
提问by gpojd
I am not a fan of using SQL*PLUS as an interface to Oracle. I usually use yasql, but it hasn't been updated since 2005 and can do with some improvements. A quick Google searchshows yasql and SQLPal. I am using linux, so SQLPal is not an option.
我不喜欢使用 SQL*PLUS 作为 Oracle 的接口。我通常使用yasql，但它自 2005 年以来一直没有更新，可以做一些改进。一个快速的谷歌搜索显示 yasql 和SQLPal。我使用的是 linux，所以 SQLPal 不是一个选项。
Are there any alternatives out there, or am I stuck with an interface that I do not like or one that is no longer maintained?
有没有其他选择，或者我是否坚持使用我不喜欢的界面或不再维护的界面？
采纳答案by ropable
I presume that you want a low-overhead method of knocking out queries, but want more functions than SQL*Plus provides? Why not use Oracle's SQL Developer? It's free.
我想您想要一种低开销的方法来取消查询，但是想要比 SQL*Plus 提供的功能更多的功能？为什么不使用 Oracle 的SQL Developer呢？免费。
Install, make a new connection to your database, then just start typing a script. Press F5 to run it (or just the part of the script that you've highlighted).
安装，与数据库建立新连接，然后开始输入脚本。按 F5 运行它（或只是您突出显示的脚本部分）。
回答by Dan Vinton
回答by Ray
回答by SqlRyan
TOAD is pretty expensive, but you can download a 90-day trial from the Quest site to see if it's got the feature set you want (don't be fooled by the "freeware" title - it's only free for 90 days, and then it expires, which definitely makes it shareware):
TOAD 非常昂贵，但您可以从 Quest 网站下载 90 天试用版，看看它是否具有您想要的功能集（不要被“免费软件”标题所迷惑——它只有 90 天免费，然后它过期了，这肯定使它成为共享软件）：
http://www.toadworld.com/Freeware/ToadforOracleFreeware/tabid/558/Default.aspx
http://www.toadworld.com/Freeware/ToadforOracleFreeware/tabid/558/Default.aspx
Another options is a tool I've seen on CodeProject:
另一个选项是我在 CodeProject 上看到的一个工具：
http://www.codeproject.com/KB/database/OQuery.aspx
http://www.codeproject.com/KB/database/OQuery.aspx
It's in .NET, so you'd have to see if it compiled on Mono, but it might be worth a shot. I haven't used either tool (Toad or this one), since I'm a SQL Server guy, but I've heard good things about Toad.
它在 .NET 中，因此您必须查看它是否在 Mono 上编译，但它可能值得一试。我没有使用过任何一种工具（Toad 或这个），因为我是一名 SQL Server 专家，但我听说过关于 Toad 的好消息。
回答by SqlRyan
回答by 0xdb
Take a look at Senora. This tool is written in Perl and therefore is cross platform. Also Senora is free, extensible and intends to be your primary Oracle shell. You can extend Senora easily by providing you own plugins. Senora attempts to provide a friendlier output formatting than sqlplus. Columns tend to be only as wide a really needed.
看看塞诺拉。这个工具是用 Perl 编写的，因此是跨平台的。此外，Senora 是免费的、可扩展的，并打算成为您的主要 Oracle shell。您可以通过提供自己的插件轻松扩展 Senora。Senora 尝试提供比 sqlplus 更友好的输出格式。列往往只有真正需要的宽度。
Another interesting alternative is SQLcl. It provides in-line editing, statement completion, command recall, DBA stuff (e.g. startup, shutdown) and also supporting your previously written SQL*Plus scripts.
另一个有趣的选择是SQLcl。它提供内嵌编辑、语句完成、命令调用、DBA 内容（例如启动、关闭）并支持您以前编写的 SQL*Plus 脚本。
回答by Khb
You could try PL/SQL developer from allroundautomations, there is a trial available and the price is much lower than TOAD.
你可以尝试从PL / SQL开发人员allroundautomations，有一个试用上市，价格比蟾蜍要低得多。
Regards K
问候 K
回答by Gary Myers
It depends what you are looking for. If it is a GUI query tool, then Oracle have their free SQL Developer product (though it has a hefty footprint). There's a few free cross-database ones too. I like SQUirrel SQL client myself. There's also DBVisualiser and a few others. JEdit is an editor that has a DBConsole plugin for running database queries and DML/DDL. They are all java based so run most places.
这取决于你在寻找什么。如果它是一个 GUI 查询工具，那么 Oracle 有他们的免费 SQL Developer 产品（尽管它占用空间很大）。还有一些免费的跨数据库的。我自己喜欢 SQUirrel SQL 客户端。还有 DBVisualiser 和其他一些。JEdit 是一个编辑器，它有一个 DBConsole 插件，用于运行数据库查询和 DML/DDL。它们都是基于 Java 的，因此可以在大多数地方运行。
If you like a command line, check out sqlpython (the developer has identified a couple of others too)
如果你喜欢命令行，检查出sqlpython（开发商已经确定了其他几个太）
回答by JaseAnderson
I like SQL Developer. It's free, has an intuitive UI, and runs on Windows, Mac, and Linux. It also supports many sql*plus commands and supports version control
我喜欢SQL 开发人员。它是免费的，具有直观的用户界面，可在 Windows、Mac 和 Linux 上运行。它还支持很多 sql*plus 命令并支持版本控制
回答by JaseAnderson
open source version of TOAD is TORA: tora.sourceforge.net
TOAD 的开源版本是 TORA： tora.sourceforge.net
