Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚoracle×Ö·û¼¯


 
·ÖÀࣺ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£©±ä³¤¶à×Ö½Ú±àÂë
     Ä³Ð©×Ö·ûÓÃÒ»¸ö×Ö½Ú±íʾ£¬ÆäËü×Ö·ûÓÃÁ½¸ö»ò¶à¸ö×Ö·û±íʾ£¬±ä³¤¶à×Ö½Ú±àÂë³£ÓÃÓÚ¶ÔÑÇÖÞÓïÑÔµÄÖ§³Ö£¬   ÀýÈçÈÕÓï¡¢ººÓï¡¢Ó¡µØÓïµÈ
    ÀýÈ磺AL32UTF8£¨ÆäÖÐAL´ú±íALL,Ö¸ÊÊÓÃÓÚËùÓÐÓïÑÔ£©¡¢zhs16cgb231280
    £¨2£©¶¨³¤¶à×Ö½Ú±àÂë
    Ã¿Ò»¸ö×Ö·û¶¼Ê¹Óù̶¨³¤¶È×ֽڵıàÂë·½°¸£¬Ä¿Ç°oracleΨһ֧³ÖµÄ¶¨³¤¶à×Ö½Ú±àÂëÊÇAF16UTF16£¬Ò²ÊǽöÓÃÓÚ¹ú¼Ò×Ö·û¼¯
2.2.3 unicode±àÂë
    UnicodeÊÇÒ»¸öº­¸ÇÁËÄ¿Ç°È«ÊÀ½çʹÓõÄËùÓÐÒÑÖª×Ö·ûµÄµ¥Ò»±àÂ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ÔÚlinuxÉÏsilent°²×°oracle¼òÖ±ÊÇÒ»³¡Ø¬ÃÎ

 Parsing command line arguments:
    Parameter "silent" = true
java.lang.ArrayIndexOutOfBoundsException: 2
        at oracle.net.ca.CmdlineArgs.parseArgs(Unknown Source)
        at oracle.net.ca.I ......

SQL ServerºÍOracle³£Óú¯Êý¶Ô±È


Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as in ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ