摘要：Oracle創建視圖實現獲取當前數據所在的頁數，這里以每頁2條數據分頁，詳細請看：

一：

DROP VIEW MIP.TB_CMS_FLGTINFO_D_VIEW;/* Formatted on 2014/12/4 8:35:36 (QP5 v5.115.810.9015) */
CREATE OR REPLACE FORCE VIEW MIP.TB_CMS_FLGTINFO_D_VIEW
(ID,A_TOBT,A_WEATHER,ABNS,ACFT,AIRLINE,ASAT,BCTM,BOTM,BETM,C_TOBT,COBT,CTOT,DINT,DLAB,DNAP,DOUT,DPRT,EDDI,EOBT,EPGT,EPOT,FATD,FFID,FLIGHTMARK,FLIGHTNUMBER,FSTD,GROUNDDISTRIBUTION,INTERNALORINTERNATIONAL,LMDT,LMUR,OFTM,PARK,RENO,RWAY,STDI,STND,TERMINAL,TSAT,SDEC,ROW_NUMBER,PAGE_SIZE
)
ASSELECT   t."ID",t."A_TOBT",t."A_WEATHER",t."ABNS",t."ACFT",t."AIRLINE",t."ASAT",t."BCTM",t."BOTM",t."BETM",t."C_TOBT",t."COBT",t."CTOT",t."DINT",t."DLAB",t."DNAP",t."DOUT",t."DPRT",t."EDDI",t."EOBT",t."EPGT",t."EPOT",t."FATD",t."FFID",t."FLIGHTMARK",t."FLIGHTNUMBER",t."FSTD",t."GROUNDDISTRIBUTION",t."INTERNALORINTERNATIONAL",t."LMDT",t."LMUR",t."OFTM",t."PARK",t."RENO",t."RWAY",t."STDI",t."STND",t."TERMINAL",t."TSAT",t."SDEC",ROWNUM AS ROW_NUMBER,DECODE (MOD (ROWNUM, 2),0, TRUNC (ROWNUM / 2),TRUNC (ROWNUM / 2) + 1)AS PAGE_SIZEFROM   TB_CMS_FLGTINFO_D tORDER BY   t.FSTD DESC;