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

Oracle±Ê¼Ç

Oracle µÄ´úÂë±íʾ¼°ÊÂÀý
 
1.  select + xxx + from + xxx   //²éѯÓï¾ä  xxx ±íʾһ¸ö±í  
     Select  *  from  + xxx   // * ±íʾһ¸öÁбíÖÐËùÓеÄÄÚÈÝ
 
  Àࣺ 1£©//  select * from country
 
     2£©//  select vLastName, vFirstName from externalcandidate
 
       “--”±íʾµ¥ÐÐ×¢ÊÍ
      “/*  ...   */ ”±íʾ¶àÐÐ×¢ÊÍ
2.  desc + xxx   // ²é¿´±íµÄ½á¹¹  recruit
   desc externalcandidate
3.  select cCountryCode "±àºÅ",cCountry "¹ú¼Ò" from country; //°Ñ±êÌâÃû×Ö»»ÁË
 
4. select distinct cCity from externalcandidate
   ¼ÓÁ˸ödistinct£¬±íʾûÓÐÖظ´µÄÁË£¬Öظ´ÏÔʾһ¸ö¡£Èç¹ûÊÇÁ½ÁеĻ°ÓÐÁ½¸ö¶¼ÊÇÖظ´µÄ»°£¬¾Í±£ÁôÒ»¸ö
 
   select distinct cCity,CState from college 
 
 
5.ÔËËã·û
  and
  or
  not
  ||     Á¬½ÓÁ½¸ö×Ö·û´®£¬°ÑÁ½ÁеÄÊý¾ÝºÏµ½Ò»ÆðÈ¥ÁË
      
  È磺select vLastName || vFirstName from externalcandidate
            //°ÑÁ½ÁеÄÊý¾ÝºÏÆðÀ´µÄ±êÌâÃû×Ö»»ÁË
    select vLastName || vFirstName "name" from externalcandidate
            //°ÑÁ½ÁеÄÊý¾ÝºÏÆðÀ´Ö®¼ä¼ÓÒ»¸öµã
             select vLastName ||  '.' ||vFirstName "name" from externalcandidate
             //°ÑÁ½ÁеÄÊý¾ÝºÏÆðÀ´Ö®¼ä¼ÓÒ»¸ö×Ö·û´®
             select vLastName || 'von' ||vFirstName "name" from externalcandidate
 
6.   //°ÑÁгöµÄÊý¾Ý³ËÉÏ5µÄ½á¹ûÊǶàÉÙ
     select nAnnualsalary * 5 from An


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Íêȫɾ³ýOracleÊý¾Ý¿â

  ºÜ¶àÅóÓÑÖ»ÓÃÁËOracleµÄɾ³ý£¬µ«ºÜ¶àÇé¿öÏ£¬Ëû»á·¢ÏÖÖØа²×°Ê±£¬µãÁËÏÂÒ»²½°²×°½çÃæ¾ÍÏûʧÁË£¬ÍùÍùÎÞÄÎÏÂÖ»ºÃÖØװϵͳ£¬ÆäʵֻÊÇÄãÊý¾Ý¿âûɾ¸É¾»£¬É¾¸É¾»¾Í²»»á³öÏÖÕâÖÖÇé¿öÁË¡£
¡¡¡¡ÊµÏÖ·½·¨£º
¡¡¡¡1¡¢¿ªÊ¼->ÉèÖÃ->¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
¡¡¡¡2¡¢¿ªÊ¼->³ÌÐò->Oracl ......

oracleÖÐrownumµÄÓ÷¨

 
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂΪתÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......

hpux+slvm+mc/sg+oracle 10g racʵʩÊÖ²á

 Ó²¼þ»·¾³:hp rx2660*2+hp eva4400
Èí¼þ»·¾³:hpux 11.23,oracle 10g for hpux,oracle clusterware,mc/serviguard 11.18
1.°²×°HPUX
2.´ò²¹¶¡,²ÎÕÕÎĵµ¼´¿É,»ò´òµ½magepatch dec.12.07ÒÔºóÒ²¿ÉÒÔ
3.°²×°mc/sg+SGeRAC(hp MC/ServiceguardΪÅäºÏoracle racËùʹÓõÄÄ£¿é)
4.¹æ»®´æ´¢
lock vg:1G
rac:100G
5.ÐÞ¸ÄÄÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ