Oracle ×Ö·û¼¯µÄ²é¿´ºÍÐÞ¸Ä
< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
if (text && text.length > 300) {
text = text + "\r\n\n±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£º" + location.href;
clipboardData.setData("text", text);
}
}, 100);
}
}
http://blog.csdn.net/tianlesoftware/archive/2009/12/01/4915223.aspx
Ò»¡¢Ê²Ã´ÊÇ
Oracle
×Ö·û¼¯
Oracle
×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ
,
ÓдóС֮·Ö
,
ÓÐÏ໥µÄ°üÈݹØÏµ¡£
ORACLE
Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£Ëüʹ
Êý¾Ý¿â
¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔºÍÆ½Ì¨¡£
Ó°Ïì
Oracle
Êý¾Ý¿â×Ö·û¼¯×îÖØÒªµÄ²ÎÊýÊÇ
NLS_LANG
²ÎÊý¡£
ËüµÄ¸ñʽ
ÈçÏÂ
: NLS_LANG = language_territory.charset
ËüÓÐÈý¸ö×é³É²¿·Ö
(
ÓïÑÔ¡¢µØÓòºÍ×Ö·û¼¯
)
£¬Ã¿¸ö³É·Ö¿ØÖÆÁË
NLS
×Ó¼¯µÄÌØÐÔ¡£
ÆäÖÐ
:
Language
£º
Ö¸¶¨·þÎñÆ÷ÏûÏ¢µÄÓïÑÔ£¬
Ó°ÏìÌáʾÐÅÏ¢ÊÇÖÐÎÄ»¹ÊÇÓ¢ÎÄ
Territory
£º
Ö¸¶¨·þÎñÆ÷µÄÈÕÆÚºÍÊý×Ö¸ñʽ£¬
Charset
£º
Ö¸¶¨×Ö·û¼¯¡£
Èç
:AMERICAN _ AMERICA. ZHS16GBK
´Ó
NLS_LANG
µÄ×é³ÉÎÒÃÇ¿ÉÒÔ¿´³ö£¬ÕæÕýÓ°ÏìÊý¾Ý¿â×Ö·û¼¯µÄÆäʵÊǵÚÈý²¿·Ö
¡£
ËùÒÔÁ½¸öÊý¾Ý¿âÖ®¼äµÄ×Ö·û¼¯Ö»ÒªµÚÈý²¿·ÖÒ»Ñù¾Í¿ÉÒÔÏ໥µ¼Èëµ¼³öÊý¾Ý£¬Ç°ÃæÓ°ÏìµÄÖ»ÊÇÌáʾÐÅÏ¢ÊÇÖÐÎÄ»¹ÊÇÓ¢ÎÄ
¡£
¶þ£®×Ö·û¼¯µÄÏà¹ØÖªÊ¶£º
2.1
×Ö·û¼¯
ʵÖʾÍÊǰ´ÕÕÒ»¶¨µÄ×Ö·û±àÂë·½°¸£¬¶ÔÒ»×éÌØ¶¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬÊýÖµ±àÂëµÄ¼¯ºÏ¡£
Oracle
Êý¾Ý¿â×îÔçÖ§³ÖµÄ±àÂë·½°¸ÊÇ
US7ASCII
¡£
Oracle
µÄ
Ïà¹ØÎĵµ£º
oracleÊý¾Ý¿âµÄÓŵãÒ»£º
ORACLE7.XÒÔÀ´ÒýÈëÁ˹²ÏíSQLºÍ¶àÏßË÷·þÎñÆ÷Ìåϵ½á¹¹¡£Õâ¼õÉÙÁËORACLEµÄ×ÊÔ´Õ¼Ó㬲¢ÔöÇ¿ÁËORACLEµÄÄÜÁ¦£¬Ê¹Ö®Ôڵ͵µÈíÓ²¼þƽ̨ÉÏÓýÏÉÙµÄ×ÊÔ´¾Í¿ÉÒÔÖ§³Ö¸ü¶àµÄÓû§£¬¶øÔڸߵµÆ½Ì¨ÉÏ¿ÉÒÔÖ§³Ö³É°ÙÉÏǧ¸öÓû§¡£
oracleÊý¾Ý¿âµÄÓŵã¶þ£º
ÌṩÁË»ùÓÚ½ÇÉ«(ROLE)·Ö¹¤µÄ°²È«±£ÃܹÜÀí¡£ÔÚÊý¾Ý¿â¹ÜÀí¹¦ÄÜ ......
LoadBalance ¾ÍÊǰѸºÔØÆ½¾ùµÄ·ÖÅäµ½¼¯ÈºÖеĸ÷¸ö½Úµã£¬´Ó¶øÌá¸ßÕûÌåµÄÍÌÍÂÄÜÁ¦¡£ Oracle 10g RAC ÌṩÁËÁ½ÖÖ²»Í¬µÄ·½·¨À´·ÖÉ¢¸ºÔØ£º
1. ͨ¹ýConnection Balancing£¬°´ÕÕijÖÖËã·¨°ÑÓû§·ÖÅäµ½²»Í¬µÄ½Úµã¡£Ò²¿ÉÈÏΪÊÇ´¿¼¼ÊõµÄ·ÖÉ¢¸ºÔØ¡£
2. ͨ¹ýService£¬ÔÚÓ¦ÓòãÉϽøÐзÖÉ¢£¬Ò ......
Ò». ¼ì²é¹²ÏíÉ豸
Ò»°ãÇé¿öÏ£¬ ´æ·ÅOCR ºÍ Voting Disk µÄOCFS2 »òÕßraw ¶¼ÊÇ×Ô¶¯Æô¶¯µÄ¡£ Èç¹ûËûÃÇûÓÐÆô¶¯£¬RAC ¿Ï¶¨ÊÇÆô¶¯²»Á˵ġ£
1.1 Èç¹ûʹÓÃocfs2µÄ£¬¼ì²éocfs2 ״̬
/etc/init.d/o2cb status
ÔÚ¹ÒÔØÖ®Ç°£¬/etc/init.d/o2cb st ......
1>.NUMBERÀàÐÍϸ½²£º
Oracle number datatype Óï·¨£ºNUMBER[(precision [, scale])]
¼ò³Æ£ºprecision --> p
scale --> s
NUMBER(p, s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+1 ......
Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......