Àí½âORACLEÊý¾Ý¿â×Ö·û¼¯
Ò»£®ÒýÑÔ
ORACLE
Êý¾Ý¿â×Ö·û¼¯£¬¼´Oracle
È«Çò»¯Ö§³Ö(Globalization Support)
£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS
£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLE
ΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle
¿ÉÒÔÖ§³Ö¶àÖÖÓïÑÔ¼°×Ö·û¼¯£¬ÆäÖÐoracle8i
Ö§³Ö48
ÖÖÓïÑÔ¡¢76
¸ö¹ú¼ÒµØÓò¡¢229
ÖÖ×Ö·û¼¯£¬¶øoracle9i
ÔòÖ§³Ö57
ÖÖÓïÑÔ¡¢88
¸ö¹ú¼ÒµØÓò¡¢235
ÖÖ×Ö·û¼¯¡£ÓÉÓÚoracle
×Ö·û¼¯ÖÖÀà¶à£¬ÇÒÔÚ´æ´¢¡¢¼ìË÷¡¢Ç¨ÒÆoracle
Êý¾Ýʱ¶à¸ö»·½ÚÓë×Ö·û¼¯µÄÉèÖÃÃÜÇÐÏà¹Ø£¬Òò´ËÔÚʵ¼ÊµÄÓ¦ÓÃÖУ¬Êý¾Ý¿â¿ª·¢ºÍ¹ÜÀíÈËÔ±¾³£»áÓöµ½ÓйØoracle
×Ö·û¼¯·½ÃæµÄÎÊÌâ¡£±¾ÎÄͨ¹ýÒÔϼ¸¸ö·½Ãæ²ûÊö£¬¶Ôoracle
×Ö·û¼¯×ö¼òÒª·ÖÎö
¶þ£®×Ö·û¼¯»ù±¾ÖªÊ¶
2.1
×Ö·û¼¯
ʵÖʾÍÊǰ´ÕÕÒ»¶¨µÄ×Ö·û±àÂë·½°¸£¬¶ÔÒ»×éÌØ¶¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬÊýÖµ±àÂëµÄ¼¯ºÏ¡£Oracle
Êý¾Ý¿â×îÔçÖ§³ÖµÄ±àÂë·½°¸ÊÇUS7ASCII
¡£
Oracle
µÄ×Ö·û¼¯ÃüÃû×ñÑÒÔÏÂÃüÃû¹æÔò
:
<Language><bit size><encoding>
¼´: <
ÓïÑÔ><
±ÈÌØÎ»Êý><
±àÂë
>
±ÈÈç: ZHS16GBK
±íʾ²ÉÓÃGBK
±àÂë¸ñʽ¡¢16
루Á½¸ö×Ö½Ú£©¼òÌåÖÐÎÄ×Ö·û¼¯
2.2
×Ö·û±àÂë·½°¸
<st1:chsdate year="1899" month="12" day="30" islunardate="False" isrocdate="False" w:st="on">2.2.1
</st1:chsdate>
µ¥×Ö½Ú±àÂë
£¨1
£©µ¥×Ö½Ú7
λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå128
¸ö×Ö·û£¬×î³£ÓõÄ×Ö·û¼¯Îª
US7ASCII
£¨2
£©µ¥×Ö½Ú8
λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå256
¸ö×Ö·û£¬ÊʺÏÓÚÅ·Ö޴󲿷ֹú¼Ò
ÀýÈ磺WE8ISO8859P1(
Î÷Å·¡¢8
λ¡¢ISO
±ê×¼8859P1
±àÂë
)
2.2.2
¶à×Ö½Ú±àÂë
£¨1
£©±ä³¤¶à×Ö½Ú±àÂë
ijЩ×Ö·ûÓÃÒ»¸ö×Ö½Ú±íʾ£¬ÆäËü×Ö·ûÓÃÁ½¸ö»ò¶à¸ö×Ö·û±íʾ£¬±ä³¤¶à×Ö½Ú±àÂë³£ÓÃÓÚ¶ÔÑÇÖÞÓïÑÔµÄÖ§³Ö£¬
ÀýÈçÈÕÓï¡¢ººÓï¡¢Ó¡µØÓïµÈ
ÀýÈ磺AL32UTF8
£¨ÆäÖÐAL
´ú±íALL,
Ö¸ÊÊÓÃÓÚËùÓÐÓïÑÔ£©¡¢
zhs16cgb231280
£¨2
£©¶¨³¤¶à×Ö½Ú±àÂë
&nbs
Ïà¹ØÎĵµ£º
Òª½øÐÐѹÁ¦²âÊÔ£¬Öмä¼þʹÓÃWEBLOGIC 816
£¬Êý¾Ý¿â°æ±¾Îª11.1.0.6 RAC
£¬Ñ¹Á¦²âÊÔ¹¤¾ßΪLOADRUNNER 8.0
¡£²âÊÔµ¥ÊµÀýÓëRAC
»·¾³¸÷¸ö½ÚµãµÄ¸ºÔØÇé¿ö¡£
ÔÚWEBLOGIC
ÉÏÅäÖÃÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGIC
ÌṩµÄ¸ºÔؾùºâ²ßÂÔ£¬½«²¢·¢¾ùºâµÄ·Ö±ðµ½Á½¸ö½ÚµãÉÏ¡£
µ«ÊDzâÊÔ·¢ÏÖ£¬Ò»µ©ÔËÐÐ
ÁËÒ»¶Îʱ¼ä£¬ËùÓе ......
תÖÁ(http://xsb.itpub.net/post/419/33028)
22/06/2005 12:22 FP
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ
×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊǶÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÀý×ÓÖÐʹÓõıíÀ´×ÔOracle×Ô´øµÄHRÓû§ÏÂµÄ±í£¬Èç¹û
ûÓа²×°¸ÃÓû§£¬¿ÉÒÔÔÚSYSÓû§ÏÂÔËÐÐ ......
ORACLE ÖÐSQL Óï¾ä´óÖ¿ÉÒÔ·ÖΪ4´óÀà
1.DQL£¨data quary language Êý¾Ý²éѯÓïÑÔ£©
Êý¾Ý²éѯÓïÑÔDQL»ù±¾½á¹¹ÊÇÓÉSELECT×Ӿ䣬from×Ӿ䣬WHERE×Ó¾ä×é³É
2.DDL£¨data definition language Êý¾Ý¶¨ÒåÓïÑÔ£©
CREATE
ALTER
DROP
RENAME
TRUNCATE
3.DML£¨data manipulation language Êý¾Ý²Ù×ÝÓïÑÔ£©
INSERT
UPDATE
......
dc-test2<oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 19:23:35 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> desc v$datafile;
SP2-0640: Not connected
SP2-0641: "DESCRIBE" requires connection to server
SQL> conn / a ......
dc-test2<oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 22:44:25 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL> define
DEFINE _DATE = ......