SQLPLUS 会话来记住历史
我刚刚开始在 Oracle 中使用 sqlplus,这太可怕了,我试图寻找想法,看看是否有人有任何围绕 sqlplus 编写的脚本,它存储历史记录,而且它的工作方式更像是一个编辑器。
I have just started using sqlplus for oracle and it is horrible, I was trying to look for ideas if anyone has any scripts written around sqlplus which stores history and and it works more like an editor.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您可能需要考虑使用 YASQL,http://sourceforge.net/projects/yasql/,它是用 Perl 编写的替代客户端。
它非常简洁,涵盖了人们对 DB CLI 客户端的大部分期望。但它并不支持
sqlplus
所做的一切。You might want to consider using YASQL, http://sourceforge.net/projects/yasql/, which is an alternative client written in Perl.
It is pretty neat and covers most of what one would expect from a DB CLI client. It does not support everything
sqlplus
does, though.您想要的是极其方便的
rlwrap
命令。它将包装几乎所有命令并添加 readline 风格的命令历史记录和编辑。它支持颜色、自定义补全以及所有爵士音乐。我不确定我提供给 rlwrap 的链接是否是“官方”源代码,编译它有时会很痛苦,但您最喜欢的 Unix 软件包源代码应该有某个可用版本。What you want is the extremely handy
rlwrap
command. It will wrap almost any command and add readline-style command history and editing. It supports, colors, custom completions, and all that jazz. I'm not sure if the link I provided torlwrap
is the "official" source, and compiling it can sometimes be a pain, but your favorite Unix package source should have some version of it available.