查询当前字符集

select property_value,property_name from database_properties where property_name like ‘%CHARACTERSET

SYS@ sky2>show parameter nls

指定地域范围影响货币显示

alter session set nls_territory=china;
alter session set nls_territory=america;
select to_char(sal,’L9,000.00’) sal from scott.emp where deptno = 10;

指定日期显示方式

alter session set nls_date_language=american;
select sysdate from dual;
select to_char(sysdate,’yyyy.mm.dd hh24:mi:ss’,’nls_date_language=american’) from dual;

排序

select * from scott.upsort order by nlssort(t,’nls_sort=schinese_radical_m’);