日期:2014-05-16  浏览次数:20431 次

oracle常用维护语句

1、如何查询Oracle 编码格式http://write.blog.csdn.net/postedit

select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

VALUE
--------------------------------------------

ZHS16GBK

2、查询oracle客户端编码

select * from nls_instance_parameters where parameter='NLS_LANGUAGE';
PARAMETER                                             VALUE

NLS_LANGUAGE                               SIMPLIFIED CHINESE