摘要: 这段脚本可以直接在PLSQL中查出Oracle服务端字符集的同时,也在Cmd窗口中显示出本地Oracle客户端字符。 以下脚本直接复制到PLSQL的Command窗口中运行即可,如果有更好的脚本请帮忙贴一下。thx. CL --Query NLS_LANGUAGE_NLS_TERRITORY.NLS_CHARACTERSET From V$NLS_PARAMETERS SELECT 'HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_LANG' as Client, t1.value||'_'||t2.VALUE||'.'||t3.VALUE AS Server FROM V$NLS_PARAMETERS t1,V$NLS_PARAMETERS t2,V$NLS_PARAMETERS t3 WHERE t1.PARAMETER='NLS_LANGUAGE' AND t2.PARAMETER='NLS_TERRITORY' AND t3.PARAMETER='NLS_CHARACT 阅读全文
posted @ 2009-10-07 23:16 Eric-Liu 阅读(606) 评论(0) 推荐(0) 编辑