我是Oracle10g的普通用户,在PL/SQL Developer的命令窗口里输入
SQL> alter session set nls_territory=france;
显示:
Session altered
但是我输入
SQL> show parameter nls_territory;
显示
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string CHINA
请问是不是因为我没有alter session的缘故,还是管理员在哪里做了手脚的缘故,请言明
SQL> alter session set nls_territory=france;
显示:
Session altered
但是我输入
SQL> show parameter nls_territory;
显示
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string CHINA
请问是不是因为我没有alter session的缘故,还是管理员在哪里做了手脚的缘故,请言明
我用sys进去修改,也是这样到底为什么呢?不知道,我查查再说
(为什么CSDN不让我插SQL? 那个代码的框框呢?)SQL> show parameter nls_territory;NAME TYPE VALUE
------------------------------------ ----------- ------------------------
nls_territory string AMERICASQL> alter session set nls_territory="CHINA";靠靠靠SQL> show parameter nls_territory;NAME TYPE VALUE
------------------------------------ ----------- -----------
nls_territory string AMERICASQL> alter system set nls_territory="CHINA" scope = spfile;靠靠靠SQL> show parameter nls_territory;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string AMERICA
SQL> alter system set nls_territory="CHINA" scope = both;
alter system set nls_territory="CHINA" scope = both
*
?1 靠靠?
ORA-02096: 靠靠靠靠靠靠靠?
SQL> shutdown immediate;
靠靠靠靠
靠靠靠靠
ORACLE 靠靠靠?
SQL> conn / as sysdba;
靠靠靠靠?
SQL> startup
ORACLE 靠靠靠?Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 260049796 bytes
Database Buffers 343932928 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> show parameter nls_territory;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string CHINA
SQL> 搞定~~~~~
为什么我想插sql的时候找不到[SQL][/SQL]的那个框框?
为什么我不能删自己传错的资源?
为什么我想发300分的帖子CSDN不让?捏CSDN开发人员的小鸡鸡~~~~~~~~~~
我以scott/tiger进去
scott@KAILIAO> show parameter nls_territory;
ORA-00942: 表或视图不存在
scott@KAILIAO> show parameter nls_territory;
ORA-00942: 表或视图不存在
PARAMETER VALUE
---------------------------------------------------------------- --------------------------------NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY ¥
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
19 rows selected
SQL> alter session set nls_territory=france;
Session altered
SQL> select * from v$nls_parameters;
PARAMETER VALUE
---------------------------------------------------------------- ---------------------------------NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY FRANCE
NLS_CURRENCY €
NLS_ISO_CURRENCY FRANCE
NLS_NUMERIC_CHARACTERS ,
NLS_CALENDAR GREGORIAN其实已经生效了,NLS类参数应该查的是这张视图