更新时间:2022-12-03 11:12:08
在Oracle SQL Developer
-
更新
OP说"文本无法理解,它像这样显示 "
特定于语言环境的NLS字符集可能不支持这些字符.也可能是多字节字符.我建议将结果SPOOL
保存为HTML
文件,并用browser
打开它,因为大多数浏览器都能够显示多个字符集,因此您可以查看内容.
Probably, the locale-specific NLS characterset doesn't support those characters. It might also be that those are Multi-Byte characters. I would suggest, SPOOL
the result to an HTML
file, open it with your browser
, you could view the content as most of the browsers are capable of displaying multiple charactersets.
您可以通过SQL * Plus执行类似的操作-
You could do something like this from SQL*Plus -
SET MARKUP HTML ON SPOOL ON
SPOOL report.html
select substr(clob_column, 1, 32767) from table_name...
SPOOL OFF
更新2
关于SPOOL作为HTML,测试用例-
Regarding SPOOL as HTML, test case -
SET MARKUP HTML ON SPOOL ON
SPOOL D:\report.html
SELECT substr(ename, 1, 5) ename FROM emp where rownum <=5;
SPOOL OFF
对我来说完美地工作,用我的浏览器打开html文件,查看屏幕截图-
Works perfectly for me, html file opens up with my browser, look at the screenshot -