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

oracle֪ʶ£¨Ò»£©


sql½Å±¾£¬Ò²¾ÍÊÇÔÚÎļþÖÐдÓÐsqlÓï¾äµÄÎļþ£¬¿ÉÒÔÔÚsqlplusÖÐÔËÐС£
ÒýÈësql½Å±¾
sqlplus Óû§Ãû/ÃÜÂë @sql½Å±¾.sql
£¨×¢Ò⣺ÔÚÓû§ÃûÃÜÂëÊäÈë½áÊøºóÒ»¶¨Òª¼Ó¿Õ¸ñÈ»ºóÔÙд@sql½Å±¾£©
OracleÖеĿÕÖµ»áµ±×÷ÎÞÇî´ó´¦Àí£¬Æäʵ¿ÕÖµ¸ù±¾¾Í²»»á´æ´¢£¬Ö»ÊÇ¿´×÷ÊÇÎÞÇî´ó¡£
OracleÖпØÖÆ´¦Àíº¯Êý NVL(×Ö¶ÎÃû£¬Öµ)£¬Õâ¸ö×Ö¶ÎÖеĿÕÖµÌæ»»ÎªÖ¸¶¨Öµ£¬Èç¹û²»Îª¿Õ£¬Ôò»á·µ»ØÆäÔ­Öµ¡£
Àý£ºselect (salary*12)*(NVL(commission_pct,0)/100+1) salary,first_name
from s_emp;
 
distinct¹Ø¼ü×Ö£¬È¥µôÖØ¸´ÐУ¨Õâ¸ö¹Ø¼ü×ֻᴦ·¢ÅÅÐò²Ù×÷£©
Àý£º select distinct dept_id,title from s_emp;
 
×¢Ò⣺distinct£¬¹Ø¼ü×ÖÖ®ºó»á¶Ôfrom֮ǰµÄ×ֶνøÐÐÅÅÖØ²Ù×÷¡£
 
columnÃüÁÕâÊǸösqlplusÃüÁ
 
columnÃüÁî ÁиñʽµÄ¶¨Òå
column Ä¿±êÁÐÃû ²é¿´Õâ¸öÀàÊÇ·ñ¶¨ÒåÁ˸ñʽ
 
column Ä¿±êÁÐÃû format a.. ÉèÖÃÁпí
 
column last_name heading 'Employee|Name'£¨ÉèÖÃÌâÍ·£© FORMAT A15
ÕâÆäÖеÄ'|'ÊÇ»»Ðзû
 
column salary justify left format $99,990.00£¨¶¨ÒåÊý×ÖÏÔʾ¸ñʽ£©
×¢Ò⣺Èç¹û²»Âú×ãÏÔʾµÄ¸ñʽ£¬¾Í»á°ÑÊý¾ÝÏÔʾΪ"#"
 
column ÁÐÃû clear £¨Çå³ýÁиñʽ¶¨Ò壩
 
×¢Ò⣺ֻÓÐsqlplusÃüÁî²ÅÓмòд£¬²¢ÇÒÔÚʹÓÃsqlplusÃüÁîʱ½áβҲ²»Äܼӷֺš£
 
Ñ¡Ôñ²Ù×÷
 
order by ÅÅÐò×Ó¾ä ASC£¨Ä¬ÈÏ£¬ÉýÐò£© DESC£¨½µÐò£©
 
order by Ä¿±êÁÐÃû£¨±ðÃû£© ÅÅÐò˳Ðò£¨²»Ð´ÅÅÐò˳Ðò£¬»áĬÈÏΪÉýÐòÅÅÐò£©
 
Àý£ºselect first_name from s_emp order by first_name;
    select first_name from s_emp order by first_name desc;
 
×¢Ò⣺ÉýÐò¿ÕÖµÔÚ½á¹ûµÄĩ⣬½µÐò¿ÕÖµÔÚ½á¹ûµÄ×îÇ°Ãæ¡£
 
where×Ó¾ä
 
where×Ó¾äʹÓÃÔÚ select ... from ... ºóÃæ£¬ÓÃÀ´Ñ¡ÔñËùÐ裨·ûºÏÌõ¼þµÄ£©µÄ¼Ç¼
 
whereºóÃæ¸úµÄÊDZí´ïʽ Ò²¾ÍÊÇ XXX=XXX£¬ XXX between X and X  £¬XXX in£¨X£¬X£¬X£©
like '...' Í¨Åä²éѯ
 
between ... and ... ,±íʾ½á¹ûÔÚÕâÖ®¼ä£¬between andÊÇÒ»¸ö±ÕÇø¼ä£¬
Ò²¾ÍÏ൱ÓÚ... <


Ïà¹ØÎĵµ£º

OracleϵÁУºLOB´ó¶ÔÏó´¦Àí

 OracleϵÁУºLOB´ó¶ÔÏó´¦Àí
 Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£
 Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
 
Ò»£¬OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
 1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
  ¢Ù×Ö·ûÀàÐÍ£º
 &nbs ......

oracle forallÓï¾ä

 FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......

Oracle AWR ½éÉÜ

Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆÎª MMON µÄеĺó ......

OracleµÄOpenWorld:ÁªÊÖSun¶ÔÕ½IBM

 ½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£­15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾ­À­¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......

oracle management server£¨oms£©Æô¶¯ÎÊÌâ

 
      ÅäÖÃÒ»¸ö¹ÜÀí×ÊÁϿ⣬Æô¶¯£ºConfiguration and Migration tools/Enterprise Manager Configuration Assistant¡£ÔÚÅäÖòÙ×÷ÖÐÑ¡ÔñÅäÖñ¾µØµÄoracle management server/´´½¨Ò»¸öеÄ×ÊÁϿ⵵°¸/µäÐÍ¡£ÏµÍ³½«»á´´½¨Ò»¸öÃûΪoemrepµÄÊý¾Ý¿â£¬±£´æ¹ÜÀíÐÅÏ¢£¬ÆäÖÐÄãÐèÒªÖ¸¶¨sysºÍsystemÕÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ