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

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
ÓÃÀ´´æ´¢¸¡µãÊý


Ïà¹ØÎĵµ£º

Oracle ¿ª·¢³£¼ûÎÊÌâ

 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µÄÐòÁУ¨Sequence£©Ê¹ÓÃ

OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......

oracle 8i,9iºÍ10g µÄÇø±ð

Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
 ¼òҪ˵£º
    9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
    9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......

Íêȫɾ³ýOracle


ʵÏÖ·½·¨£º
     1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
     2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ