oracleµÄÊý¾ÝÀàÐÍ
ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£
ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
¢ÙÊý×Ö
¡¡
ÓÐÈýÖÖ»ù±¾ÀàÐÍ:NUMBER¡¢PLS_INTEGERºÍBINARY_INTENER¡£
NUMBER
¿ÉÒÔÃèÊöÕûÊý»òʵÊý£¬¶øPLS_INTEGERºÍBINARY_INTENERÖ»ÄÜÃèÊöÕûÊý¡£ NUMBER£¬ÊÇÒÔÊ®½øÖƸñʽ½øÐд洢µÄ£¬Ëü±ãÓÚ´æ´¢£¬µ«ÊÇÔÚ¼ÆËãÉÏ£¬ÏµÍ³»á×Ô¶¯µÄ½«Ëüת»»³ÉΪ¶þ½øÖƽøÐÐÔËËãµÄ¡£ËüµÄ¶¨Ò巽ʽÊÇNUMBER(P£¬S)£¬PÊǾ«¶È£¬×î´ó38룬SÊǿ̶ȷ¶Î§£¬¿ÉÔÚ-84...127¼äȡֵ¡£ÀýÈ磺NUMBER(5£¬2)¿ÉÒÔÓÃÀ´´æ´¢±íʾ-999.99...999.99 ¼äµÄÊýÖµ¡£
P¡¢S¿ÉÒÔÔÚ¶¨ÒåÊÇÊ¡ÂÔ£¬ÀýÈ磺NUMBER(5)¡¢NUMBERµÈ£»
BINARY_INTENER
ÓÃÀ´ÃèÊö²»´æ´¢ÔÚÊý¾Ý¿âÖУ¬µ«ÊÇÐèÒªÓÃÀ´¼ÆËãµÄ´ø·ûºÅµÄÕûÊýÖµ¡£ËüÒÔ2µÄ²¹Âë¶þ½øÖÆÐÎʽ±íÊö¡£Ñ»·¼ÆÊýÆ÷¾³£Ê¹ÓÃÕâÖÖÀàÐÍ¡£
PLS_INTEGER
ºÍBINARY_INTENERÎ¨Ò»Çø±ðÊÇÔÚ¼ÆËãµ±Öз¢ÉúÒç³öʱ£¬BINARY_INTENERÐ͵ıäÁ¿»á±»×Ô¶¯Ö¸ÅɸøÒ»¸öNUMBERÐͶø²»»á³ö´í£¬PLS_INTEGERÐ͵ıäÁ¿½«»á·¢Éú´íÎó¡£
¢Ú×Ö·û¡¡°üÀ¨CHAR¡¢VARCHAR2(VARCHAR)¡¢LONG¡¢NCHARºÍNVARCHAR2¼¸ÖÖÀàÐÍ¡£
CHAR¡¡
ÃèÊö¶¨³¤µÄ×Ö·û´®£¬Èç¹ûʵ¼ÊÖµ²»¹»¶¨ÒåµÄ³¤¶È£¬ÏµÍ³½«ÒÔ¿Õ¸ñÌî³ä¡£ËüµÄÉùÃ÷·½Ê½ÈçÏÂ
CHAR(L)¡¡
LΪ×Ö·û´®³¤¶È£¬È±Ê¡Îª1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£
VARCHAR2(VARCHAR)
¡¡ÃèÊö±ä³¤×Ö·û´®¡£ËüµÄÉùÃ÷·½Ê½ÈçÏ VARCHAR2(L)£¬LΪ×Ö·û´®³¤¶È£¬Ã»ÓÐȱʡֵ£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö½Ú£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ4000¡£ÔÚ¶à×Ö½ÚÓïÑÔ»·¾³ÖУ¬Êµ¼Ê´æ´¢µÄ×Ö·û¸öÊý¿ÉÄÜСÓÚLÖµ£¬ÀýÈ磺µ±ÓïÑÔ»·¾³ÎªÖÐÎÄ(SIMPLIFIED CHINESE_CHINA.ZHS16GBK)ʱ£¬Ò»¸öVARCHAR2(200)µÄÊý¾ÝÁпÉÒÔ±£´æ200¸öÓ¢ÎÄ×Ö·û»òÕß100¸öºº×Ö×Ö·û¡£
LONG
¡¡ÔÚÊý¾Ý¿â´æ´¢ÖпÉÒÔÓÃÀ´±£´æ¸ß´ï2GµÄÊý¾Ý£¬×÷Ϊ±äÁ¿£¬¿ÉÒÔ±íʾһ¸ö×î´ó³¤¶ÈΪ32760×ֽڵĿɱä×Ö·û´®¡£
NCHAR¡¢NVARCHAR2
¡¡¹ú¼Ò×Ö·û¼¯£¬Óë»·¾³±äÁ¿NLSÖ¸¶¨µÄÓïÑÔ¼¯ÃÜÇÐÏà¹Ø£¬Ê¹Ó÷½·¨ºÍCHAR¡¢VARCHAR2Ïàͬ¡£
¢ÛÐÐ
°üÀ¨RAWºÍLONG RAWÁ½ÖÖÀàÐÍ¡£ÓÃÀ´´æ´¢¶þ½øÖÆÊý¾Ý£¬²»»áÔÚ×Ö·û¼¯¼äת»»¡£
RAW
ÀàËÆÓÚCHAR£¬ÉùÃ÷·½Ê½RAW(L)£¬LΪ³¤¶È£¬ÒÔ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÊÕ²ØÓÚhttp://dev.yesky.com/296/8090796.shtml
OracleÊý¾Ý¿â
ÖйÜÀí±í¿Õ¼äºÍÊý¾ÝÎļþ
Êý¾Ý¿âµÄÈý´ó×é³É²¿·Ö:Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬RedoÈÕÖ¾¡£
±í¿Õ¼ä·ÖΪϵͳ±í¿Õ¼äºÍ·Çϵͳ±í¿Õ¼ä¡£
SYSTEM±í¿Õ¼äÊÇ×î»ù±¾µÄ£¬±ØÐëµÄ£¬Oracle½¨ÒéÄãΪÓû§Êý¾Ý£¬Óû§Ë÷Òý£¬UndoÊý¾Ý¶Î£¬ÁÙʱÊý¾Ý¶Î´´½¨µ¥¶ÀµÄ±í¿Õ¼ä ......
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......
oracleÈçºÎ½«Êý¾Ýµ¼Èëµ½ÁíÒ»¸ö±í¿Õ¼ä
ij¸öÓû§µÄÊý¾ÝÔÚUSER±í¿Õ¼äÀÈç¹û¶à¸öÓû§µÄÊý¾Ý¶¼ÔÚUSERS±í¿Õ¼äÄÚ£¬½«ÑÏÖØÓ°ÏìϵͳÐÔÄÜ£¬Ò»°ãÔÚÏµÍ³Ç¨ÒÆµÄʱºò£¬ÔÚеÄϵͳÀïÏ£Íûµ¼ÈëÒ»¸ö¶ÀÁ¢µÄÓû§±í¿Õ¼ä£¬µ«ÊǾ³£ÎÞ·¨µ¼ÈëÓû§Ö¸¶¨µÄȱʡ±í¿Õ¼ä£¬Õâ¸öÎÊÌâ²úÉúµÄÔÒòÊÇÈç¹ûÒ»¸öÓû§ÓÐDBAµÄȨÏÞ£¬µ¼ÈëÊý¾Ýµ ......