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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ºÜ¶àÅóÓÑÖ»ÓÃÁËOracleµÄɾ³ý£¬µ«ºÜ¶àÇé¿öÏ£¬Ëû»á·¢ÏÖÖØа²×°Ê±£¬µãÁËÏÂÒ»²½°²×°½çÃæ¾ÍÏûʧÁË£¬ÍùÍùÎÞÄÎÏÂÖ»ºÃÖØװϵͳ£¬ÆäʵֻÊÇÄãÊý¾Ý¿âûɾ¸É¾»£¬É¾¸É¾»¾Í²»»á³öÏÖÕâÖÖÇé¿öÁË¡£
¡¡¡¡ÊµÏÖ·½·¨£º
¡¡¡¡1¡¢¿ªÊ¼->ÉèÖÃ->¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
¡¡¡¡2¡¢¿ªÊ¼->³ÌÐò->Oracl ......
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂΪתÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......
Ó²¼þ»·¾³: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.ÐÞ¸ÄÄÚ ......