OracleÖÐʵÏÖ·ÖÒ³µÄ·½·¨
	
    
    
	---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄǰÌáϽøÐÐ×ªÔØ£»
---- ×ªÔØÎñ±Ø×¢Ã÷Ôʼ³ö´¦
:
 http://blog.csdn.net/andkylee
--- 2010-05-31 22:56:43
---- ¹Ø¼ü×Ö£º oracle ·ÖÒ³ rownum
----------------------------------------------------------------------------
ÔÚoracleÖÐÏÔʾ·ÖÒ³ºÜ¼òµ¥£¬ ÀûÓÃÁ½´Îrownum¾ÍʵÏÖÁË¡£
ÏÂÃæµÄÓï¾äÓÃÀ´·µ»ØDBA_OBJECTS±íÖÐÀàÐÍΪTABLEµÄËùÓмǼÖеĵÚ100ÐÐÖÁµÚ200ÐС£ 
select * from
( select rownum rnm, a.* from ( select OBJECT_NAME from DBA_OBJECTS where object_type='TABLE' ) a 
    where rownum <= 200 )
where rnm > 100
Ö´Ðнá¹ûΪ£º
SQL> select * from
  2  ( select rownum rnm, a.* from ( select OBJECT_NAME from DBA_OBJECTS where object_type='TABLE' ) a
  3      where rownum <= 200 )
  4  where rnm > 100
  5  ;
       RNM OBJECT_NAME
---------- --------------------------------------------------------------------------------------------------------------------
       101 HISTGRM$
       102 HIST_HEAD$
       103 DUAL
       104 PARTOBJ$
       105 PARTCOL$
       106 TABPART$
       107 INDPART$
       108 SUBPARTCOL$
       109 TABSUBPART$
       110 INDSUBPART$
       111 TABCOMPART$
       RNM OBJECT_NAME
---------- --------------------------------------------------------------------------------------------------------------------
       112 INDCOMPART$
       113 PARTLOB$
       114 LOBFRAG$
       115 LOBCOMPPART$
       116 DEFSUBPART$
       117 DEFSUBPARTLOB$
       118 SYSTEM_PRIVILEGE_MAP
       119 TABLE_PRIVILEGE_MAP
       120 STMT_AUDIT_OPTION_MAP
       121 RESOURCE_MAP
       122 USER_ASTATUS_MAP
       RNM OBJECT_NAME
---------- --------------------------------------------------------------------------------------------------------------------
       123 EXPACT$
       124 NOEXP$
       125 PROCEDUREJAVA$
       126 PROCEDUREC$
       127 PROCEDUREPLSQL$
       128 RESULT$
 
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    Åú´¦Àí£¨batÎļþ£© ×Ô¶¯Æô¶¯/¹Ø±Õoracle·þÎñ
ÅжÏoracle ·þÎñ״̬
Èç¹û·þÎñ´¦ÓÚÆô¶¯×´Ì¬£¬¾Í¹Ø±Õ·þÎñ£»
Èç¹û·þÎñ´¦ÓڹرÕ״̬£¬¾ÍÆô¶¯·þÎñ¡£
@ECHO OFF  
for /f "skip=3 tokens=4" %%i in ('sc query OracleServiceORCL') do set "zt=%%i" &goto :next 
:next
if /i "%zt%"=="RUNNING" (
	ECHO Stoping Oracle ......
	
    
        
    
    
Exam Number/Code : 1z0-047 
Exam Name : Oracle Database SQL Expert 
Questions and Answers : 278 Q&As 
Update Time: 2010-04-15 
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns th ......
	
    
        
    
    
Exam Number/Code : 1z0-047 
Exam Name : Oracle Database SQL Expert 
Questions and Answers : 278 Q&As 
Update Time: 2010-04-15 
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns th ......
	
    
        
    
    author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......