一条常用的oracle维护语句

核心提示： 1、如何查询Oracle 编码格式http://write.blog.csdn.net/posteditselect value from nls_database_parameters where parameter='NLS_CHARACTERSET';VALUEZHS16GBK2、查询oracl

 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