Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ʹÓõÄhintsµ÷Õû»úÖÆ

 
10gÊý¾Ý¿â½éÉÜ£º¿ÉÒÔʹÓøü¶àеÄoptimizer hintsÀ´¿ØÖÆÓÅ»¯ÐÐΪ¡£ÏÖÔÚÈÃÎÒÃÇ¿ìËÙ½âÎöÒ»ÏÂÕâЩǿ´óµÄÐÂhints:
spread_min_analysis

ʹÓÃÕâÒ»hint£¬Äã¿ÉÒÔºöÂÔһЩ¹ØÓÚÈçÏêϸµÄ¹ØÏµÒÀÀµÍ¼·ÖÎöµÈµç×Ó±í¸ñµÄ±àÒëʱ¼äÓÅ»¯¹æÔò¡£ÆäËûµÄһЩÓÅ»¯£¬Èç´´½¨¹ýÂËÒÔÓÐÑ¡ÔñÐԵĶ¨Î»µç×Ó±í¸ñ·ÃÎʽṹ²¢ÏÞÖÆÐÞ¶©¹æÔòµÈ£¬µÃµ ......

OracleÊý¾Ý¿âµÄ±¸·Ý¼°»Ö¸´²ßÂÔÑо¿

1¡¢¶à¹¤Áª»úÖØ×÷ÈÕÖ¾Îļþ
¡¡¡¡Ã¿¸öÊý¾Ý¿âʵÀý¶¼ÓÐÆä×Ô¼ºµÄÁª»úÖØ×÷ÈÕÖ¾×飬ÔÚ²Ù×÷Êý¾Ý¿âʱ£¬OracleÊ×ÏȽ«Êý¾Ý¿âµÄÈ«²¿¸Ä±ä±£´æÔÚÖØ×÷ÈÕÖ¾»º³åÇøÖУ¬ËæºóÈÕÖ¾¼Ç¼Æ÷½ø³Ì£¨LGWR£©½«Êý¾Ý´Óϵͳ¹²ÓÃÇøSGA£¨System Global Area£©µÄÖØ×÷ÈÕÖ¾»º³åÇøÐ´ÈëÁª»úÖØ×÷ÈÕÖ¾Îļþ£¬ÔÚ´ÅÅ̱ÀÀ£»òʵÀýʧ°Üʱ£¬¿ÉÒÔͨ¹ýÓëÖ®Ïà¹ØµÄÁª»úÖØ×÷ÈÕÖ¾ ......

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ºÅ