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%)
Ïà¹ØÎĵµ£º
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄǰÌáϽøÐÐ×ªÔØ£»
---- ×ªÔØÎñ±Ø×¢Ã÷Ôʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 22:56:43
---- ¹Ø¼ü×Ö£º oracle ·ÖÒ³ rownum
--------------------------------- ......
‘¿ªÊ¼’-->‘ÔËÐÐ’--> ÊäÈë‘cmd’ ´ò¿ªcmd.exe -->ÊäÈë‘cd c:\’ Çл»µ½ c:\>
Æô¶¯Oracle
c:\> svrmgrl
svrmgrl> connect internal/oracle
svrmgrl> startup
svrmgrl> exit
Æô¶¯¼àÌýÆ÷
c:\> lsnrctl start ......