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

oracle_°Ù·Ö±È¼ÆËã

select round(sum(case when o.close_date is null then 1 else 0 end)/count(*),3)*100||'%'  SCALE from order o
˵Ã÷£ºÊ¹ÓÃsum¶ÔÒ»¶¨Ìõ¼þµÄÊý¾ÝÇóºÍºó£¬Óë×ÜÊý½øÐбȽϡ£
         ||'%' ÎªÒԵİٷֺÅÐÎʽÊä³ö½á¹û(Àý£º2%)


Ïà¹ØÎĵµ£º

Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö

Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£ 
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
 
1 create or replace procedure NoParPro
2 as  ;
3 begin
4 ;
5 exception  &nb ......

oracleË÷ÒýË鯬

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

oracleËéÆ¬Ð¡½á

author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌË鯬£¬ÒòΪ´ÅÅÌË鯬»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾ­ºÜ·ÑÁ¦Á˰¡£¬Èç¹ûÔÙÓдóÁ¿
µÄË鯬£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéÆ¬ÒªÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......

ÈçºÎÅäÖúÍÖØ½¨Oracle 10GµÄem·þÎñ dbcontrol

Oracle10GµÄEM²ÉÓÃÁËweb·½Ê½£¬²¢ÇÒ·Ö³ÉÁË2¸ö²úÆ·£¬database controlºÍgrid control¡£ÕâÀïÖ÷Òª½éÉÜÈçºÎ´´½¨µ¥Êý¾ÝµÄdbcontrol¡£Grid controlÐèÒªÏÂÔØµ¥¶ÀµÄ¹âÅ̰²×°¡£
ÔÚÓÃDBCA½¨¿âµÄʱºò£¬¿ÉÒÔÑ¡ÔñÊÇ·ñÆôÓÃdbcontrol£¬ÆôÓõϰÐèÒªÔÚ
Êý¾Ý¿â
Öн¨Á¢Ò»¸ösysmanµÄschema£¬ÓÃÓÚ±£´æEMµÄһЩÊý¾Ý£¬Õâ¸ö¾ÍÊÇEMµÄ×ÊÁÏ¿â(reposi ......

ת:ORACLE ¶à±í¹ØÁª UPDATE Óï¾ä


ת:ORACLE
¶à±í¹ØÁª UPDATE Óï¾ä
Ô­Ìû£ºhttp://www.cnblogs.com/miley/archive/2010/04/15/1712617.html
  ΪÁË
·½±ãÆð¼û
,½¨Á¢ÁËÒÔϼòµ¥Ä£ÐÍ
,ºÍ¹¹ÔìÁ˲¿·Ö²âÊÔÊý¾Ý
:
   ÔÚij¸öÒµ
ÎñÊÜÀí×Óϵͳ
BSSÖУ¬
  --¿Í»§×Ê
Áϱí
  create table customers
   (
 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ