格式化SQLPlus中查询的输出 [英] Formatting output of queries in SQLPlus
本文介绍了格式化SQLPlus中查询的输出的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
而且,有谁能告诉我在哪里可以得到Ubuntu的SQLPlus?
干杯,
解决方案
好的,从SQL Plus开始:
SET LINESIZE 20000 TRIM ON TRIMSPOOL ON
SPOOL output.txt
- 在这里运行您的查询
SPOOL OFF
EXIT
另外,RenéNyffenegger 专门介绍美化SQL * Plus输出和 SQL * Plus上的额外资源。
I'm working with SQLPlus at the moment and whenever I query the Database, the result is in a complete mess. In other words, it is hard to read. I wonder if anyone knows how to format the output of queries ( columns, tables.. etc) in SQLPlus that is running on Unix server. But, I am accessing the server from my windows.
And, Could anyone tell me where I can get SQLPlus for Ubuntu from?
Cheers,
解决方案
Okay, start with this in SQL Plus:
SET LINESIZE 20000 TRIM ON TRIMSPOOL ON
SPOOL output.txt
-- run your queries here
SPOOL OFF
EXIT
Also, René Nyffenegger has a whole section dedicated to Beautifying SQL*Plus Output and additional resources on SQL*Plus.
这篇关于格式化SQLPlus中查询的输出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文