oracle 分頁(yè)查詢語(yǔ)句：
select * from ( select row_.*, rownum rownum_ from (
sql--你要查詢的語(yǔ)句，支持order by) row_ where rownum <=
MAXROW ) where rownum_ >
MINROW
示例：
insert into M2_USER_POINT (id, iuserid, iconsumepoint, isumepoint, iisdelete)
select seq_m2_user_point.nextval as id ,iuserid, iconsumepoint, isumepoint,iisdelete from ( select row_.*, rownum rownum_ from (
select iuserid, iconsumepoint, isumepoint,'0' as iisdelete
from v_club_point
) row_ where rownum <= 10000) where rownum_ >0;
posted on 2005-08-15 09:16
wilin 閱讀(213)
評(píng)論(0) 編輯 收藏 所屬分類:
數(shù)據(jù)庫(kù)相關(guān)