Oracle创建视图实现获取当前数据所在的页数，这里以每页2条数据分页

客官°小女子只卖身不卖艺 2024-02-17 15:24 11阅读 0赞

摘要：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;