问题描述
我不喜欢使用SQL*Plus作为Oracle的接口.我通常会使用 yasql ,但是自2005年以来就没有进行更新,并且可以通过一些改进来进行.快速 google search 显示yasql和 sqlpal .我正在使用Linux,因此SQLPAL不是一个选择.
有其他替代方案,还是我不喜欢的接口或不再维护的界面?
推荐答案
我假设您想要一种低空的方法来淘汰查询,但是想要比SQL*Plus提供更多功能?为什么不使用Oracle的 sql开发人员?它是免费的.
安装,建立与数据库的新连接,然后开始键入脚本.按F5运行它(或您突出显示的脚本的一部分).
其他推荐答案
看一下 gqlplus .它在Linux上包装SQL*Plus,并通过添加命令历史记录,表名完成等内容使其更加用户友好.
其他推荐答案
emacs 可以提供更强大的文本编辑和功能以外的功能默认的SQL*Plus命令行接口.
这里有一些有关如何使用Emacs作为SQL*Plus的包装器的链接:
问题描述
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 search shows yasql and SQLPal. I am using linux, so SQLPal is not an option.
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?
推荐答案
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.
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).
其他推荐答案
Take a look at gqlplus. It wraps sql*plus on linux and makes it more user-friendly by adding things like command history, table name completion and so on.
其他推荐答案
Emacs can provide so much more powerful text editing features and functionality beyond the default SQL*Plus command-line interface.
Here are a few links on how to use Emacs as a wrapper for SQL*Plus: