Oracle 9iµÄÊý¾ÝÀàÐÍ
Oracle 9i¹²ÌṩÁË16ÖÖ±êÁ¿Êý¾ÝÀàÐÍ£¬Èç±í7.4Ëùʾ¡£
±í7.4 Oracle 9iµÄ±êÁ¿Êý¾ÝÀàÐÍ
Ãû³Æ
º¬Òå
Char
ÓÃÓÚÃèÊö¶¨³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
varchar2
ÓÃÓÚÃèÊö±ä³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=4000×Ö½Ú
nchar
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ¶¨³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
nvarchar2
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ±ä³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
number
ÓÃÀ´´æ´¢ÕûÐÍ»òÕ߸¡µãÐÍÊýÖµ
Date
ÓÃÀ´´æ´¢ÈÕÆÚÊý¾Ý
Long
ÓÃÀ´´æ´¢×î´ó³¤¶ÈΪ2GBµÄ±ä³¤×Ö·ûÊý¾Ý
Raw
ÓÃÀ´´æ´¢·Ç½á¹¹»¯Êý¾ÝµÄ±ä³¤×Ö·ûÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
Long raw
ÓÃÀ´´æ´¢·Ç½á¹¹»¯Êý¾ÝµÄ±ä³¤×Ö·ûÊý¾Ý£¬³¤¶È<=2GB
rowid
ÓÃÀ´´æ´¢±íÖÐÁеÄÎïÀíµØÖ·µÄ¶þ½øÖÆÊý¾Ý£¬Õ¼Óù̶¨µÄ10¸ö×Ö½Ú
Blob
ÓÃÀ´´æ´¢¶à´ï4GBµÄ·Ç½á¹¹»¯µÄ¶þ½øÖÆÊý¾Ý
Clob
ÓÃÀ´´æ´¢¶à´ï4GBµÄ×Ö·ûÊý¾Ý
nclob
ÓÃÀ´´æ´¢¶à´ï4GBµÄUnicode×Ö·ûÊý¾Ý
Bfile
ÓÃÀ´°Ñ·Ç½á¹¹»¯µÄ¶þ½øÖÆÊý¾Ý´æ´¢ÔÚÊý¾Ý¿âÒÔÍâµÄ²Ù×÷ϵͳÎļþÖÐ
urowid
ÓÃÀ´´æ´¢±íʾÈκÎÀàÐÍÁеØÖ·µÄ¶þ½øÖÆÊý¾Ý
float
ÓÃÀ´´æ´¢¸¡µãÊý
Ïà¹ØÎĵµ£º
1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ
l S£ºselect abs(-1) value
l O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó)
l S£ºselect ceiling(-001) value
l O£ºselect ceil(-001) value from dual
¢ÛÈ¡Õû£¨Ð¡£©
l S£ºselect floor(-001) value  ......
OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......
Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
&nb ......