Oracle¿Í»§¶ËNLS_LANGÉèÖÃ
1. NLS_LANG
²ÎÊý×é³É
NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients
Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄϰ¹ß
CHARACTERSET:
-¿ØÖƿͻ§¶ËÓ¦ÓóÌÐòʹÓõÄ×Ö·û¼¯
ͨ³£ÉèÖûòÕßµÈÓÚ¿Í»§¶Ë(ÈçWindows)´úÂëÒ³
»òÕß¶ÔÓÚunicodeÓ¦ÓÃÉèÖÃΪUTF8
ÔÚWindowsÉϲ鿴µ±Ç°ÏµÍ³µÄ´úÂëÒ³¿ÉÒÔʹÓÃchcpÃüÁî:
E:\>chcp
»î¶¯µÄ´úÂëÒ³: 936
´úÂëÒ³936Ò²¾ÍÊÇÖÐÎÄ×Ö·û¼¯ GBK,ÔÚMicrosoftµÄ¹Ù·½Õ¾µãÉÏ£¬ÎÒÃÇ¿ÉÒÔÔâµ½¹ØÓÚ936´úÂëÒ³µÄ¾ßÌå±àÂë¹æÔò,Çë²Î¿¼ÒÔÏÂÁ´½Ó:
http://www.microsoft.com/globaldev/reference/dbcs/936.htm
2. ²é¿´ NLS_LANG
µÄ·½·¨
WindowsʹÓÃ:
echo %NLS_LANG
%
Èç:
E:\>echo %NLS_LANG
%
AMERICAN_AMERICA.ZHS16GBK
UnixʹÓÃ:
env|grep NLS_LANG
Èç:
/opt/oracle>env|grep NLS_LANG
NLS_LANG
=AMERICAN_CHINA.ZHS16GBK
Windows¿Í»§¶ËÉèÖÃ,¿ÉÒÔÔÚ×¢²á±íÖиü¸ÄNLS_LANG
,¾ßÌå¼üֵλÓÚ:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMExx\
xxÖ¸´æÔÚ¶à¸öORACLE_HOMEʱϵͳ±àºÅ¡£
3. ²é¿´Êý¾Ý¿âµ±Ç°×Ö·û¼¯²ÎÊýÉèÖÃ
SELECT * from v$nls_parameters;
»ò
select * from nls_database_parameters
»ò
select userenv(‘language’) from dual;
4. ²é¿´Êý¾Ý¿â¿ÉÓÃ×Ö·û¼¯²ÎÊýÉèÖÃ
SELECT * from v$nls_valid_values;
5. ¿Í»§¶Ë NLS_LANG
µÄÉèÖ÷½·¨
Windows:
# ³£ÓÃÖÐÎÄ×Ö·û¼¯
set NLS_LANG
=SIMPLIFIED
CHINESE_CHINA.ZHS16GBK
# ³£ÓÃunicode×Ö·û¼¯
set NLS_LANG
=american_america.AL32UTF8
¿ÉÒÔͨ¹ýÐÞ¸Ä×¢²á±í¼üÖµÓÀ¾ÃÉèÖÃ
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMExx\NLS_LANG
Unix:
# ³£ÓÃunicode×Ö·û¼¯
export NLS_LANG
=american_america.AL32UTF8
# ³£ÓÃÖÐÎÄ×Ö·û¼¯
export NLS_LANG
="Simplified
Chinese_china".ZHS16GBK
¿ÉÒԱ༠bash_profile Îļþ½øÐÐÓÀ¾ÃÉèÖÃ
vi .bash_profile
NLS_LANG
="Simplified
Chinese_china".ZHS16GBK export NLS_LANG
# ʹ bash_profile ÉèÖÃÉúЧ
source .bash_profile
Ïà¹ØÎĵµ£º
Ò»¡¢oracleµ¼³öexcel
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨---Óù¤¾ßplsql dev
Ö´ÐÐFile =>new Report Window ¡£ÔÚsql±êÇ©ÖÐдÈëÐèÒªµÄsql£¬µã»÷Ö´Ðлò°´¿ì½Ý¼üF8£¬»áÏȳԳö²éѯ½á¹û¡£ÔÚÓҲ๤¾ßÀ¸£¬¿ÉÒÔÑ¡Ôñ°´Å¥Áí´æÎªhtml¡¢copy as html¡¢export results£¬ÆäÖÐexport results°´Å¥ÖоͿÉÒÔµ¼³öexcelÎļþ¡¢csvÎļþ¡¢tsvÎļþ¡¢xmlÎļþ¡ ......
<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......
--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
--ÉùÃ÷Óαê
cursor mycur is select * from employees where employee_id<120;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......
OracleÔÚÖ´ÐÐÒ»¸öSQL֮ǰ,Ê×ÏÈÒª·ÖÎöÒ»ÏÂÓï¾äµÄÖ´Ðмƻ®,È»ºóÔÙ°´Ö´Ðмƻ®È¥Ö´ÐС£·ÖÎöÓï¾äµÄÖ´Ðмƻ®µÄ¹¤×÷ÊÇÓÉÓÅ»¯Æ÷(Optimizer)À´Íê³ÉµÄ¡£²»Í¬µÄÇé¿ö,Ò»ÌõSQL¿ÉÄÜÓжàÖÖÖ´Ðмƻ®,µ«ÔÚijһʱµã,Ò»¶¨Ö»ÓÐÒ»ÖÖÖ´Ðмƻ®ÊÇ×îÓŵÄ,»¨·Ñʱ¼äÊÇ×îÉٵġ£ÏàÐÅÄãÒ»¶¨»áÓÃPl/sql Developer¡¢ToadµÈ¹¤¾ßÈ¥¿´Ò»¸öÓï¾äµÄÖ´Ðмƻ®,²»¹ýÄã ......
ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÄÇôÕâÁ½ÖÖ½âÎöÓкβ»Í¬Ö®´¦ÄØ£¿ËüÃÇÓÖ·Ö±ðÊÇÈçºÎ½øÐнâÎöÄØ£¿OracleÄÚ²¿½âÎöµÄ²½ÖèÓÖÊÇÈçºÎ½øÐеÄÄØ£¿ÏÂÃæÎÒÃǾÍÕâЩ»°Ìâ½øÐй²Í¬Ì½ÌÖ¡£ ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪDDLÓï¾ä£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´ ......