Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óû§¹ÜÀí

 Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
 ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌØ¶¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
 ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
 1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
  Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......

ÈçºÎÕýȷɾ³ýORACLE¹éµµÈÕÖ¾Îļþ

 ÎÒÃǶ¼¶¼ÖªµÀÔÚcontrolfileÖмǼ×Åÿһ¸öarchivelogµÄÏà¹ØÐÅÏ¢£¬µ±È»ÃÇÔÚOSϰÑÕâЩÎïÀíÎļþdeleteµôºó£¬ÔÚÎÒÃǵÄ
controlfileÖÐÈÔÈ»¼Ç¼×ÅÕâЩarchivelogµÄÐÅÏ¢£¬ÔÚoracleµÄOEM¹ÜÀíÆ÷ÖÐÓпÉÊÓ»¯µÄÈÕÖ¾Õ¹ÏÖ³ö£¬µ±ÎÒÃÇÊÖ¹¤Çå³ýarchiveĿ¼ÏµÄÎļþºó£¬ÕâЩ¼Ç¼²¢Ã»Óб»ÎÒÃÇ´ÓcontrolfileÖÐÇå³ýµô£¬Ò²¾ÍÊÇoracle²¢²» ......

OracleÊý¾Ý¿â½µµÍHWMµÄ¼¸ÖÖ·½·¨

HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øÏ½µ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ