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

Oracle objectѧϰ±Ê¼Ç 1

 1 ¾Û¼¯(cluster)
1.1 ¸ÅÄ
ÓÃÓÚ½«²»Í¬±íÖеÄÊý¾Ý´æ´¢µ½ÏàͬµÄÎïÀíÊý¾Ý¿éÖУ¬ÓÃÓÚ¶à±íÊý¾ÝÐèҪƵ·±½øÐÐÁªºÏ²éѯµÄÇé¿öÏ¡£¶à±íÊý¾Ý´æ´¢ÔÚÏàͬÊý¾Ý¿éºó£¬ÔÚ¶Ô¶Ô±í½øÐÐÁªºÏ²éѯʱ£¬ËùÐè¶ÁÈ¡µÄÎïÀí¿éÊý¼õÉÙ£¬´Ó¶øÌá¸ß²éѯÐÔÄÜ¡£
ÐèҪעÒâµÄÊǶԾۼ¯Öе¥±íµÄ²éѯºÍ¶Ô¾Û¼¯ÖбíÊý¾Ý½øÐÐÐ޸Ļò²åÈëµÈÊÂÎñ²Ù×÷ʱ£¬ÐÔÄܽ«Êܵ½Ó°Ïì¡£
ÿһ¸ö¾Û¼¯´æ´¢ÆäÖи÷¾Û¼¯±íµÄÊý¾Ý²¢Î¬»¤¸Ã¾Û¼¯Ë÷Òý£¬ÒÔ±ã¶ÔÊý¾Ý½øÐÐÅÅÐò¡£¾Û¼¯Ë÷ÒýÖеÄË÷ÒýÁУ¬³ÆΪ¾Û¼¯¼ü£¨cluster key£©£¬Æä¾ö¶¨ÁËÊý¾ÝÔÚÎïÀíÉϵĴ洢λÖã¬ÕâЩÁв»Ó¦Ê±³£¸üС£¾Û¼¯¼üͨ³£ÊÇÆä¾Û¼¯±íÖÐͬij¸ö±íµÄÖ÷¼üÏà¹ØÁªµÄij±íµÄÍâ¼ü¡£
¾Û¼¯·ÖΪÆÕͨ¾Û¼¯ºÍ¹þÏ£¾Û¼¯Á½ÖÖ£¬Æä²Ù×÷·½·¨²»Ì«Ïàͬ¡£
1.2 ½¨Á¢£º
1.2.1 ½¨Á¢ÆÕͨ¾Û¼¯
--½¨Á¢¾Û¼¯personnel£º
CREATE CLUSTER personnel 
     ( department_number  NUMBER(2) ) 
     SIZE 512 
     STORAGE (INITIAL 100K NEXT 50K);
--½¨Á¢¾Û¼¯±íemp:
CREATE TABLE emp 
     (empno     NUMBER        PRIMARY KEY, 
      ename     VARCHAR2(10)  NOT NULL 
                CHECK (ename = UPPER(ename)), 
       job       VARCHAR2(9), 
       mgr       NUMBER        REFERENCES scott.emp(empno), 
       hiredate  DATE          
         CHECK (hiredate < TO_DATE ('08-14-1998', 'MM-DD-YYYY')), 
     sal       NUMBER(10,2)  CHECK&nb


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLEÍâÁ¬½ÓС½á~

ºÃ¼¸´ÎÏëÓõ½ÍâÁ¬½ÓµÄʱºò¶¼ÍüÁ˾ßÌåµÄÓ÷¨ÊÇÔõÑùµÄ£¬±ÈÈç˵£¨+£©¸Ã¼ÓÔڵȺŵÄÄÄÒ»¶Ë£¬»òÕßLFET OUTER JOIN¸ÃÓÃÔÚÕûÌõÓï¾äÖеÄÄĸö²¿·Ö¡£½ñÌìÕýºÃÓÖÅöµ½Ò»¸öÏà¹ØµÄÎÊÌ⣬½è´Ë»ú»á×ܽáһϣ¬ÒÔºóÒ²·½±ã²éѯ£¬²»ÓÃÿ´Î¶¼È¥°Ù¶ÈÁË¡£
//table1ºÍtable2ΪÁ½¸ö²âÊÔ±í Ëæ±ã²åÈ뼸ÌõÊý¾Ý
SQL> select * from table1;
......

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 int) v ......

Oracle ¾Û¼¯

http://blog.csdn.net/junmail/archive/2009/07/29/4392264.aspx
 ¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ­³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
 
¾­³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ