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

oracleÖµµÃ̽ÌÖµÄÎÊÌâ

¾­³£×öһЩÊý¾Ý¿â²Ù×÷£¬ÔÚ½¨Á¢±íµÄʱºò£¬Ñ¡Ôñ×Ö¶ÎÀàÐÍʱ£¬ÓйØ×Ö·û´®ÀàÐ͵ÄÑ¡Ôñ×ÜÊÇÓÐЩģºý¡£
¡£char
¡£varchar2
¡£nvarchar2
¡£nchar
¹ØÓÚÉÏÃæÁ½¸öÎÒÓеãÓ¡Ïó¡£CHARµÄ³¤¶ÈÊǹ̶¨µÄ£¬¶øVARCHAR2µÄ³¤¶ÈÊÇ¿ÉÒԱ仯µÄ£¬±ÈÈ磬´æ´¢×Ö·û´®“abc"£¬¶ÔÓÚCHAR (20)£¬±íʾÄã´æ´¢µÄ×Ö·û½«Õ¼20¸ö×Ö½Ú(°üÀ¨17¸ö¿Õ×Ö·û)£¬¶øÍ¬ÑùµÄVARCHAR2
(20)ÔòÖ»Õ¼ÓÃ3¸ö×ֽڵij¤¶È£¬20Ö»ÊÇ×î´óÖµ£¬µ±Äã´æ´¢µÄ×Ö·ûСÓÚ20ʱ£¬°´Êµ¼Ê³¤¶È´æ´¢¡£
ÍøÉϲéѯµ½£º
CHARµÄЧÂʱÈVARCHAR2µÄЧÂÊÉԸߡ£ ¡¡¡¡
ĿǰVARCHARÊÇVARCHAR2µÄͬÒå´Ê¡£¹¤Òµ±ê×¼µÄVARCHARÀàÐÍ¿ÉÒÔ´æ´¢¿Õ×Ö·û´®£¬µ«ÊÇOracle²»ÕâÑù×ö£¬¾¡¹ÜËü±£ÁôÒÔºóÕâ
Ñù×öµÄȨÀû¡£Oracle×Ô¼º¿ª·¢ÁËÒ»¸öÊý¾ÝÀàÐÍVARCHAR2£¬Õâ¸öÀàÐͲ»ÊÇÒ»¸ö±ê×¼µÄVARCHAR£¬Ëü½«ÔÚÊý¾Ý¿âÖÐvarcharÁпÉÒÔ´æ´¢¿Õ×Ö
·û´®µÄÌØÐÔ¸ÄΪ´æ´¢NULLÖµ¡£¼ÙÈçÄãÏëÓÐÏòºó¼æÈݵÄÄÜÁ¦£¬Oracle½¨ÒéʹÓÃVARCHAR2¶ø²»ÊÇVARCHAR¡£ ¡¡¡¡
ºÎʱ¸ÃÓÃCHAR£¬ºÎʱ¸ÃÓÃvarchar2£¿ ¡¡¡¡CHARÓëVARCHAR2ÊÇÒ»¶Ôì¶ÜµÄͳһÌ壬Á½ÕßÊÇ»¥²¹µÄ¹ØÏµ.
¡¡¡¡VARCHAR2±ÈCHAR½ÚÊ¡¿Õ¼ä£¬ÔÚЧÂÊÉϱÈCHAR»áÉÔ΢²îһЩ£¬¼´ÒªÏë»ñµÃЧÂÊ£¬¾Í±ØÐëÎþÉüÒ»¶¨µÄ¿Õ¼ä£¬ÕâÒ²¾ÍÊÇÎÒÃÇÔÚÊý¾Ý¿âÉè¼ÆÉϳ£ËµµÄ
‘ÒԿռ任ЧÂÊ’¡£
¡¡¡¡VARCHAR2ËäÈ»±ÈCHAR½ÚÊ¡¿Õ¼ä£¬µ«ÊǼÙÈçÒ»¸öVARCHAR2Áо­³£±»Ð޸쬶øÇÒÿ´Î±»Ð޸ĵÄÊý¾ÝµÄ³¤¶È²»Í¬£¬Õâ»áÒýÆð‘ÐÐÇ¨ÒÆ’(Row
Migration)ÏÖÏ󣬶øÕâÔì³É¶àÓàµÄI/O£¬ÊÇÊý¾Ý¿âÉè¼ÆºÍµ÷ÕûÖÐÒª¾¡Á¦±ÜÃâµÄ£¬ÔÚÕâÖÖÇé¿öÏÂÓÃCHAR´úÌæVARCHAR2»á¸üºÃһЩ¡£
²»¹ý¹ØÓÚnvarchar2ºÍnchar£¬ÓõIJ»¶à£¬ËûÃÇÓÖÓÐÊ²Ã´ÖªÊ¶ÄØ£¿


Ïà¹ØÎĵµ£º

ORACLE²éѯ³ö±íÖеÄ×Ö¶ÎÁбí

 SELECT max(SYS_CONNECT_BY_PATH(COLUMN_NAME, ','))
  from (SELECT A.COLUMN_NAME, ROWNUM AS ROWNO
          from USER_TAB_COLUMNS A
         WHERE TABLE_NAME = 'A_USER'
     ......

¹ØÓÚoracle×Ö·û¼¯


 
·ÖÀࣺOracle
Ò»£®ÒýÑÔ
    ORACLEÊý¾Ý¿â×Ö·û¼¯£¬¼´OracleÈ«Çò»¯Ö§³Ö(Globalization Support)£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLEΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle¿ÉÒÔÖ§³Ö ......

Oracle ×î³£Óù¦Äܺ¯Êý¾­µä»ã×Ü

¡¡¡¡* SQL Group Function
*
s (num can be a column or ex
pression)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡(null values are ign
*
ored, default between distin
ct and all is all)¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡********************
***************
****************************
****************
¡¡¡¡AVG([distinct or all ......

oracle ASM ÅäÖ㨰²×°dbʱ´´½¨Ñ¡Ôñasm£©

 
oracle ASM ÅäÖà ת
2008-04-30 11:14
oracle ASM ÅäÖÃ
2006Äê12ÔÂ11ÈÕ ÐÇÆÚÒ» 11:09
×Ô¶¯´æ´¢¹ÜÀí (ASM)

   ASM ÊÇ Oracle Êý¾Ý¿â 10g
ÖÐÒ»¸ö·Ç³£³öÉ«µÄÐÂÌØÐÔ£¬ËüÒÔÆ½Ì¨Î޹صķ½Ê½ÌṩÁËÎļþϵͳ¡¢Âß¼­¾í¹ÜÀíÆ÷ÒÔ¼°Èí¼þ RAID µÈ·þÎñ¡£ASM
¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬´Ó¶øÊµÏÖÁËÔÚÊý¾Ý¿â±»¼ÓÔØµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ