摘要: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
)
AS
SELECT 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_SIZE
FROM TB_CMS_FLGTINFO_D t
ORDER BY t.FSTD DESC;