[ORACLE]ORACLE ʵÏÖmysqlÖеÄlimit ¹¦ÄÜ

ÏîÄ¿´ÓmysqlǨÒƵ½ORACLEÖÐÓöµ½ÒÆÖ²ÎÊÌ⣬mysqlÖÐÖ§³Ölimit ¶øORACLE say no .
½â¾ö·½·¨ ÀûÓÃORACLEµÄαÁÐ rownumÀ´¿ØÖÆ¡£¡£
Mysql : select * from table limit 10
equl
ORACLE£º select * from table where rownum <= 10
ORACLE αÁнéÉÜ£º
ËæÊý¾Ý×ÖµäÒ»Æð×Ô¶¯´´½¨µÄÒ»¸ö±í,ÊôÓÚsysģʽ,ÈκÎÓû§¶¼¿ÉÒÔ·ÃÎÊ, Ö»ÓÐÒ»ÁÐdummy(varchar2(1)),·µ»ØÖµÒ²Ö»ÓÐÒ»ÐÐ,
Òò´Ë,ÔÚ½øÐÐselect ¼ÆËã³£Á¿±í´ïʽ»òÕßαÁÐʱ³£³£Óõ½.
oracleÖеij£Óõ½µÄαÁÐ:
ÐòÁÐ  
  currval:ÐòÁÐ當Ç°Öµ  
  nextval:ÐòÁеÄÐÂÖµ       
 
level:²ã´Î²éѯÖеIJãÊý    
  rowid:Ìض¨µÄÐбí識·û      
  rownum:ÐÐÐò號
Ó÷¨:
ÐòÁÐ:  
  create   sequence   sequence1;    
  currval:  
 
select   sequence1.currval   from   dual;  
  nextval:  
 
select   sequence1.nextval   from   dual;   
    
  ÔÚinsert  
intoÖÐÒ²¿ÉÒÔ:  
  insert   into   tableName(id1)  
values(sequence1.nextval);