Àí½â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×Ö·û±àÂë·½°¸
2.2.1 µ¥×Ö½Ú±àÂë
£¨1£©µ¥×Ö½Ú7λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå128¸ö×Ö·û£¬×î³£ÓõÄ×Ö·û¼¯ÎªUS7ASCII
£¨2£©µ¥×Ö½Ú8λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå256¸ö×Ö·û£¬ÊʺÏÓÚÅ·Ö޴󲿷ֹú¼Ò
ÀýÈ磺WE8ISO8859P1(Î÷Å·¡¢8λ¡¢ISO±ê×¼8859P1±àÂë)
2.2.2 ¶à×Ö½Ú±àÂë
£¨1£©±ä³¤¶à×Ö½Ú±àÂë
ijЩ×Ö·ûÓÃÒ»¸ö×Ö½Ú±íʾ£¬ÆäËü×Ö·ûÓÃÁ½¸ö»ò¶à¸ö×Ö·û±íʾ£¬±ä³¤¶à×Ö½Ú±àÂë³£ÓÃÓÚ¶ÔÑÇÖÞÓïÑÔµÄÖ§³Ö£¬ ÀýÈçÈÕÓï¡¢ººÓï¡¢Ó¡µØÓïµÈ
ÀýÈ磺AL32UTF8£¨ÆäÖÐAL´ú±íALL,Ö¸ÊÊÓÃÓÚËùÓÐÓïÑÔ£©¡¢zhs16cgb231280
£¨2£©¶¨³¤¶à×Ö½Ú±àÂë
ÿһ¸ö×Ö·û¶¼Ê¹Óù̶¨³¤¶È×ֽڵıàÂë·½°¸£¬Ä¿Ç°oracleΨһ֧³ÖµÄ¶¨³¤¶à×Ö½Ú±àÂëÊÇAF16UTF16£¬Ò²ÊǽöÓÃÓÚ¹ú¼Ò×Ö·û¼¯
2.2.3 unicode±àÂë
UnicodeÊÇÒ»¸öº¸ÇÁËÄ¿Ç°È«ÊÀ½çʹÓõÄËùÓÐÒÑÖª×Ö·ûµÄµ¥Ò»±àÂë·½°¸£¬Ò²¾ÍÊÇ˵UnicodeΪÿһ¸ö×Ö·ûÌṩΨһµÄ±àÂë¡£UTF-16ÊÇunicodeµÄ16λ±àÂ뷽ʽ£¬ÊÇÒ»ÖÖ¶¨³¤¶à×Ö½Ú±àÂ룬ÓÃ
Ïà¹ØÎĵµ£º
SOURCE: CLICK HERE
±¾ÎĽ²ÊöSQL Server¡¢Oracle¡¢MySQL²é³öֵΪNULLµÄÌæ»»¡£
ÔÚSQL Server Oracle MySQLµ±Êý¾Ý¿âÖвé³öijֵΪNULLÔõô°ì?
1¡¢MSSQL: ISNULL()
Óï·¨
ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
re ......
ÀûÓÃoracleÉó¼Æ¹¦ÄÜÀ´¼à²âÊÔ»·¾³µÄ±ä»¯
×ö¹ý²âÊÔµÄÈ˶¼Ó¦¸Ã»áÅöµ½ÕâÑùµÄÇé¿ö£º²âÊÔ·¢ÏÖµÄbugÔÚ¿ª·¢»úÆ÷ÉÏûÓгöÏÖ£¬ÏÔÈ»ÕâÊÇ»·¾³²îÒìµÄÔÒò¡£Ï൱¶àÇé¿öÏ£¬ÒòΪ²âÊÔʹÓõÄÊý¾Ý¿â½á¹¹ºÍ¿ª·¢Ê¹ÓõÄÊý¾Ý¿â½á¹¹²»Ò»ÖÂÔì³ÉµÄ¡£ÓÈÆäÊÇһЩ¹«Ë¾ÔÚÌá½»²âÊÔ°æ±¾µÄʱºò£¬×¢ÖØÓ¦Óà ......
¸øÍŶÓÄÚ²¿×öµÄÒ»¸öOracle Êý¾ÝÀàÐÍ·ÖÏí£¬Ö÷ÒªÊǹØÓÚOracleÊý¾ÝÀàÐÍһЩÄÚ²¿´æ´¢½á¹¹¼°ÐÔÄܽéÉÜ¡£
http://www.slideshare.net/yzsind/oracle-4317768
ÒÔÏÂÊÇPPTÖÐunDumpNumberº¯ÊýµÄÈ«²¿´úÂ룺
create or replace function unDumpNumber(iDumpStr varchar2) return number is
TYPE ByteAr ......
OracleÉó¼Æ¹¦ÄÜ
Ò»¡¢ Éó¼Æ·ÖÀࣺ
OracleÖÐÉó¼Æ×ÜÌåÉÏ¿É·ÖΪ“±ê×¼Éó¼Æ”ºÍ“ϸÁ£¶ÈÉó¼Æ”ºóÕßÒ²³ÆΪ“»ùÓÚÕþ²ßµÄÉó¼Æ”£¬ÔÚOracle10GÖ®ºó¹¦Äܵõ½ºÜ´óÔöÇ¿¡£ÆäÖбê×¼Éó¼Æ¿É·ÖΪÓû§¼¶Éó¼ÆºÍϵͳ¼¶Éó¼Æ¡£Óû§¼¶Éó¼ÆÊÇÈκÎOracleÓû§¿ÉÉèÖõÄÉó¼Æ£¬Ö÷ÒªÊÇÓû§Õë¶Ô×Ô¼º´´½¨ ......
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
3.±í·ÖÇøµÄÓÅȱµã
4.±í·ÖÇøµÄ¼¸ÖÖÀàÐ ......