oracle惯用维护语句

oracle常用维护语句1、如何查询Oracle 编码式http://write.blog.csdn.net/posteditselect value from nls_d

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