各位大神,求助!
我自己学习Oracle时在SQL Developer上运行的,输入以下代码:
select * from dept;desc emp;select empno,ename,sal,job from emp;Alter session set nls_date_language='SIMPLIFIED CHINESE';
select ename,hiredate from emp;Alter session set nls_date_language='AMERICAN';
select ename,hiredate from emp;Alter session set nls_date_language='YYYY"年"MM"月"DD"日"';
select ename,hiredate from emp;当测试到
Alter session set nls_date_language='YYYY"年"MM"月"DD"日"';
这一行时出现了求解决方法!
我自己学习Oracle时在SQL Developer上运行的,输入以下代码:
select * from dept;desc emp;select empno,ename,sal,job from emp;Alter session set nls_date_language='SIMPLIFIED CHINESE';
select ename,hiredate from emp;Alter session set nls_date_language='AMERICAN';
select ename,hiredate from emp;Alter session set nls_date_language='YYYY"年"MM"月"DD"日"';
select ename,hiredate from emp;当测试到
Alter session set nls_date_language='YYYY"年"MM"月"DD"日"';
这一行时出现了求解决方法!
或 注册表里的
NLS_LANG 项的值设为:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
或 注册表里的
NLS_LANG 项的值设为:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
应该是Alter session set nls_date_format='YYYY"年"MM"月"DD"日"';
NLS_LANG 项的值设为:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
但是导出的命令行是乱码了