informix 分頁

informix 分頁處理

一 設定 執行時間顯示

export DBACCESS_SHOW_TIME=1

二 測試SQL

> set explain on; 

執行計劃見: /home/informix/sqexplain.out

1 使用ROWNUM 無效率

> select * from ( select tmp_page.*, rownum row_id from ( select   t1.id    

                            ,   t1.user_id                        ,  

    t1.user_name                      ,   t1.address                        , 

     t1.matter                         ,   t1.lendmoney                      ,

      t1.traffic                        ,   t1.leavedate                     

    ,   t1.backdate                       ,   t1.summary                      

     ,   t1.allowance                      ,   t1.last_update_date            

      ,   t1.last_updated_by                ,   t1.creation_date              

       ,   t1.created_by                     ,   t1.last_update_ip            

        ,   t1.version                        ,   t1.attribute_01             

         ,   t1.attribute_02                   ,   t1.attribute_03            

          ,   t1.attribute_04                   ,   t1.attribute_05           

           ,   t1.attribute_06                   ,   t1.attribute_07          

            ,   t1.attribute_08                   ,   t1.attribute_09         

             ,   t1.attribute_10                     from demo_business_trip 

    t1         order by t1.creation_date desc ) tmp_page where rownum <= 45 )

    where row_id > 30;

15 row(s) retrieved.

Elapsed time: 30.445 sec

> select * from ( select tmp_page.*, rownum row_id from ( select   t1.id    

                            ,   t1.user_id                        ,  

    t1.user_name                      ,   t1.address                        , 

     t1.matter                         ,   t1.lendmoney                      ,

      t1.traffic                        ,   t1.leavedate                     

    ,   t1.backdate                       ,   t1.summary                      

     ,   t1.allowance                      ,   t1.last_update_date            

      ,   t1.last_updated_by                ,   t1.creation_date              

       ,   t1.created_by                     ,   t1.last_update_ip            

        ,   t1.version                        ,   t1.attribute_01             

         ,   t1.attribute_02                   ,   t1.attribute_03            

          ,   t1.attribute_04                   ,   t1.attribute_05           

           ,   t1.attribute_06                   ,   t1.attribute_07          

            ,   t1.attribute_08                   ,   t1.attribute_09         

             ,   t1.attribute_10                     from demo_business_trip 

    t1         order by t1.creation_date desc ) tmp_page where rownum <= 6000045 )

    where row_id > 6000030;

15 row(s) retrieved.

Elapsed time: 57.142 sec

2 使用 skip 語句 提高性能 比較

--傳回 rowid和所有字段

> select skip 0 first 15 rowid, * from demo_business_trip t1 order by t1.creation_date desc;

Elapsed time: 0.004 sec

The final cost of the plan is reduced because of the FIRST n specification in

 the query.

  Table map :

  ----------------------------

  Internal name     Table name

  ----------------------------

  t1                t1

  type     table  rows_prod  est_rows  rows_scan  time       est_cost

  -------------------------------------------------------------------

  scan     t1     15         6311654   15         00:00.00   3       

> select skip 6200036 first 15 rowid, * from demo_business_trip t1 order by t1.creation_date desc;

Elapsed time: 7.648 sec

The final cost of the plan is reduced because of the FIRST n specification in

 the query.

  Table map :

  ----------------------------

  Internal name     Table name

  ----------------------------

  t1                t1

  type     table  rows_prod  est_rows  rows_scan  time       est_cost

  -------------------------------------------------------------------

  scan     t1     6200051    6311654   6200051    00:07.64   1289790 

--隻傳回 rowid

> select skip 6200036 first 15 rowid  from demo_business_trip t1 order by t1.creation_date desc;

Elapsed time: 1.686 sec

The final cost of the plan is reduced because of the FIRST n specification in

 the query.

  Table map :

  ----------------------------

  Internal name     Table name

  ----------------------------

  t1                t1

  type     table  rows_prod  est_rows  rows_scan  time       est_cost

  -------------------------------------------------------------------

  scan     t1     6200051    6311654   6200051    00:01.68   190197  

下面2例使用分别使用了 存儲過程與臨時表 和 函數與LIST 的組合 

比較結果:存儲過程與臨時表  比 函數與LIST 的組合  稍微快些，但是 函數與LIST 的組合 直接傳回結果

3 使用存儲過程，臨時表

測試表結構: DEMO_BUSINESS_TRIP

CREATE TABLE DEMO_BUSINESS_TRIP(

    ID VARCHAR(50) NOT NULL,

    USER_ID VARCHAR(50) NOT NULL,

    USER_NAME VARCHAR(50),

    ADDRESS VARCHAR(100),

    MATTER LVARCHAR(500),

    LENDMONEY INT8,

    TRAFFIC VARCHAR(50),

    LEAVEDATE DATETIME YEAR TO FRACTION (5),

    BACKDATE DATETIME YEAR TO FRACTION (5),

    SUMMARY LVARCHAR(4000),

    ALLOWANCE DECIMAL(16,2),

    LAST_UPDATE_DATE DATETIME YEAR TO FRACTION (5) NOT NULL,

    LAST_UPDATED_BY VARCHAR(50) NOT NULL,

    CREATION_DATE DATETIME YEAR TO FRACTION (5) NOT NULL,

    CREATED_BY VARCHAR(50) NOT NULL,

    LAST_UPDATE_IP VARCHAR(50) NOT NULL,

    VERSION INT8 NOT NULL,

    ATTRIBUTE_01 VARCHAR(255),

    ATTRIBUTE_02 VARCHAR(255),

    ATTRIBUTE_03 VARCHAR(255),

    ATTRIBUTE_04 VARCHAR(255),

    ATTRIBUTE_05 VARCHAR(255),

    ATTRIBUTE_06 VARCHAR(255),

    ATTRIBUTE_07 VARCHAR(255),

    ATTRIBUTE_08 VARCHAR(255),

    ATTRIBUTE_09 VARCHAR(255),

    ATTRIBUTE_10 VARCHAR(255)

);

--  get_temptable_byrowid

--功能:将按照 CREATION_DATE 排序的表傳回 某段 記錄

--本例使用臨時表

drop procedure if exists get_temptable_byrowid; 

create procedure get_temptable_byrowid(v_start int,v_end int)

define v_skip int;

define v_first int;

let v_skip=v_start;

let v_first=v_end- v_start;

--1 建立臨時表(存放ROWID)

drop table if exists t_tmp_rowid;

create temp table t_tmp_rowid(tmp_rowid int);

insert into t_tmp_rowid  select skip v_skip first v_first rowid from demo_business_trip t1 order by t1.creation_date desc;

drop table if exists tmp_demo_business_trip;

--包含 tmp_rowid字段

--不包含 tmp_rowid字段

CREATE temp TABLE tmp_DEMO_BUSINESS_TRIP( ID VARCHAR(50) NOT NULL,    USER_ID VARCHAR(50) NOT NULL,

        USER_NAME VARCHAR(50),    ADDRESS VARCHAR(100),    MATTER LVARCHAR(500),    LENDMONEY INT8,

        TRAFFIC VARCHAR(50),    LEAVEDATE DATETIME YEAR TO FRACTION (5),    BACKDATE DATETIME YEAR TO FRACTION (5),

        SUMMARY LVARCHAR(4000),    ALLOWANCE DECIMAL(16,2),    LAST_UPDATE_DATE DATETIME YEAR TO FRACTION (5) NOT NULL,

        LAST_UPDATED_BY VARCHAR(50) NOT NULL,    CREATION_DATE DATETIME YEAR TO FRACTION (5) NOT NULL,

        CREATED_BY VARCHAR(50) NOT NULL,    LAST_UPDATE_IP VARCHAR(50) NOT NULL,    VERSION INT8 NOT NULL,

        ATTRIBUTE_01 VARCHAR(255),    ATTRIBUTE_02 VARCHAR(255),    ATTRIBUTE_03 VARCHAR(255),    ATTRIBUTE_04 VARCHAR(255),

        ATTRIBUTE_05 VARCHAR(255),    ATTRIBUTE_06 VARCHAR(255),    ATTRIBUTE_07 VARCHAR(255),    ATTRIBUTE_08 VARCHAR(255),

        ATTRIBUTE_09 VARCHAR(255),    ATTRIBUTE_10 VARCHAR(255));

insert into tmp_DEMO_BUSINESS_TRIP select t1.* from demo_business_trip t1, t_tmp_rowid t2 where t1.rowid =t2.tmp_rowid ;

 end procedure;

--測試 

>

> execute procedure get_temptable_byrowid(0,15);

select id from tmp_DEMO_BUSINESS_TRIP;

Elapsed time: 0.011 sec

> 

id                                                 

8a58a6c757d1497a0157d5a166e84547                  

8a58a6c757d1497a0157d5a1651b44ff                  

8a58a6c757d1497a0157d598347042c3                  

8a58a6c757d1497a0157d58356066a89                  

8a58a6c757d1497a0157d583557b6a79                  

8a58a6c757d1497a0157d57ce7976724                  

8a58a6c757d1497a0157d57ce4d566cd                  

8a58a6c757d1497a0157d57ce40f66b8                  

8a58a6c757d1497a0157d57ce3156696                  

8a58a6c857d149c20157d578498f5a9b                  

8a58a6c757d1497a0157d57814d36131                  

8a58a6c757d1497a0157d578153c6144                  

8a58a6c757d1497a0157d57817d8617a                  

8a58a6c857d149c20157d5691175507e                  

8a58a6c857d149c20157d5690be44ffd                  

15 row(s) retrieved.

>

execute procedure get_temptable_byrowid(6111115,6111130);

select id from tmp_DEMO_BUSINESS_TRIP;

Elapsed time: 1.669 sec

> 

id                                                 

363E633D76743BD0E0534826D80A6073                  

363E633D76753BD0E0534826D80A6073                  

363E633D76763BD0E0534826D80A6073                  

363E633D76773BD0E0534826D80A6073                  

363E633D76783BD0E0534826D80A6073                  

363E633D76793BD0E0534826D80A6073                  

363E633D767A3BD0E0534826D80A6073                  

363E633D767B3BD0E0534826D80A6073                  

363E633D767C3BD0E0534826D80A6073                  

363E633D767D3BD0E0534826D80A6073                  

363E633D767E3BD0E0534826D80A6073                  

363E633D767F3BD0E0534826D80A6073                  

363E633D76803BD0E0534826D80A6073                  

363E633D76813BD0E0534826D80A6073                  

363E633D76823BD0E0534826D80A6073   

15 row(s) retrieved.

Elapsed time: 0.001 sec

> execute procedure get_temptable_byrowid(5111115,5111130);

select id from tmp_DEMO_BUSINESS_TRIP;

Elapsed time: 1.405 sec

> 

363E634CB8373BD0E0534826D80A6073                  

363E634CB8383BD0E0534826D80A6073                  

363E634CB8393BD0E0534826D80A6073                  

363E634CB83A3BD0E0534826D80A6073                  

363E634CB83B3BD0E0534826D80A6073                  

363E634CB83C3BD0E0534826D80A6073                  

363E634CB83D3BD0E0534826D80A6073                  

363E634CB83E3BD0E0534826D80A6073                  

363E634CB83F3BD0E0534826D80A6073                  

363E634CB8403BD0E0534826D80A6073                  

363E634CB8413BD0E0534826D80A6073                  

363E634CB8423BD0E0534826D80A6073                  

363E634CB8433BD0E0534826D80A6073                  

363E634CB8443BD0E0534826D80A6073                  

363E634CB8453BD0E0534826D80A6073 

15 row(s) retrieved.

Elapsed time: 0.001 sec

>

 execute procedure get_temptable_byrowid(50,65);

select id from tmp_DEMO_BUSINESS_TRIP;

Elapsed time: 0.011 sec

> 

id                                                 

8a58a6c857d149c20157d1cf037036dc                  

8a58a6c757d1497a0157d1cee2db3b61                  

8a58a6c757d1497a0157d1cedffd3ade                  

8a58a6c757d1497a0157d1ceda673a4d                  

8a58a6c757d1497a0157d1cedb263a60                  

8a58a6c757d1497a0157d1ced9833a2b                  

8a58a6c757d1497a0157d1ced73539de                  

8a58a6c757d1497a0157d1ced84739ff                  

8a58a6c757d1497a0157d1ced9ee3a3f                  

8a58a6c757d1497a0157d1ced9c53a3c                  

8a58a6c757d1497a0157d1ced09c3953                  

8a58a6c857d149c20157d1c014982d3d                  

8a58a6c857d149c20157d1c00f0b2cbd                  

8a58a6c857d149c20157d1c00fa42cce                  

8a58a6c757d1497a0157d1bfe8823047 

15 row(s) retrieved.

Elapsed time: 0.001 sec

> execute procedure get_temptable_byrowid(6200036,6200051);

select id from tmp_DEMO_BUSINESS_TRIP;

Elapsed time: 1.689 sec

> 

id                                                 

8a58a6c7557b459501557d6135ba6b7a                  

8a58a6c7557b459501557d6133ca6b6e                  

8a58a6c7557b459501557d61368a6b80                  

8a58a6c7557b459501557d6134226b71                  

8a58a6c7557b459501557d61357a6b77                  

8a58a6c7557b459501557d6131b16b63                  

8a58a6c7557b459501557d6130166b19                  

8a58a6c7557b459501557d6130a36b5d                  

8a58a6c7557b459501557d6130956b5c                  

8a58a6c7557b459501557d612d846b09                  

8a58a6c7557b459501557d612c8f6b03                  

8a58a6c7557b459501557d612d916b0a                  

8a58a6c7557b459501557d612bf36b01                  

8a58a6c7557b459501557d6127ec6aa7                  

8a58a6c7557b459501557d6128c76aae 

15 row(s) retrieved.

Elapsed time: 0.001 sec

4 使用函數 list

--  get_list_byrowid

--功能:将按照 CREATION_DATE 排序的表傳回 某段 記錄

--本例使用LIST 

drop function if exists get_list_byrowid; 

drop row type rt_DEMO_BUSINESS_TRIP restrict;

create row type rt_DEMO_BUSINESS_TRIP(

 ID VARCHAR(50) NOT NULL,

    USER_ID VARCHAR(50) NOT NULL,

    USER_NAME VARCHAR(50),

    ADDRESS VARCHAR(100),

    MATTER LVARCHAR(500),

    LENDMONEY INT8,

    TRAFFIC VARCHAR(50),

    LEAVEDATE DATETIME YEAR TO FRACTION (5),

    BACKDATE DATETIME YEAR TO FRACTION (5),

    SUMMARY LVARCHAR(4000),

    ALLOWANCE DECIMAL(16,2),

    LAST_UPDATE_DATE DATETIME YEAR TO FRACTION (5) NOT NULL,

    LAST_UPDATED_BY VARCHAR(50) NOT NULL,

    CREATION_DATE DATETIME YEAR TO FRACTION (5) NOT NULL,

    CREATED_BY VARCHAR(50) NOT NULL,

    LAST_UPDATE_IP VARCHAR(50) NOT NULL,

    VERSION INT8 NOT NULL,

    ATTRIBUTE_01 VARCHAR(255),

    ATTRIBUTE_02 VARCHAR(255),

    ATTRIBUTE_03 VARCHAR(255),

    ATTRIBUTE_04 VARCHAR(255),

    ATTRIBUTE_05 VARCHAR(255),

    ATTRIBUTE_06 VARCHAR(255),

    ATTRIBUTE_07 VARCHAR(255),

    ATTRIBUTE_08 VARCHAR(255),

    ATTRIBUTE_09 VARCHAR(255),

    ATTRIBUTE_10 VARCHAR(255)

);

create function get_list_byrowid(v_start int,v_end int)

returning  list(rt_DEMO_BUSINESS_TRIP not null)

define v_skip int;

define v_first int;

define v_DEMO_BUSINESS_TRIP_list list(rt_DEMO_BUSINESS_TRIP not null);

        define v_rt_DEMO_BUSINESS_TRIP rt_DEMO_BUSINESS_TRIP;

define v_rowid_list list(int not null);

define v_rowid int;

    define v_ID VARCHAR(50);

    define v_USER_ID VARCHAR(50);

    define v_USER_NAME VARCHAR(50);

    define v_ADDRESS VARCHAR(100);

    define v_MATTER LVARCHAR(500);

    define v_LENDMONEY INT8;

    define v_TRAFFIC VARCHAR(50);

    define v_LEAVEDATE DATETIME YEAR TO FRACTION (5);

    define v_BACKDATE DATETIME YEAR TO FRACTION (5);

    define v_SUMMARY LVARCHAR(4000);

    define v_ALLOWANCE DECIMAL(16,2);

    define v_LAST_UPDATE_DATE DATETIME YEAR TO FRACTION (5);

    define v_LAST_UPDATED_BY VARCHAR(50);

    define v_CREATION_DATE DATETIME YEAR TO FRACTION (5);

    define v_CREATED_BY VARCHAR(50);

    define v_LAST_UPDATE_IP VARCHAR(50);

    define v_VERSION INT8;

    define v_ATTRIBUTE_01 VARCHAR(255);

    define v_ATTRIBUTE_02 VARCHAR(255);

    define v_ATTRIBUTE_03 VARCHAR(255);

    define v_ATTRIBUTE_04 VARCHAR(255);

    define v_ATTRIBUTE_05 VARCHAR(255);

    define v_ATTRIBUTE_06 VARCHAR(255);

    define v_ATTRIBUTE_07 VARCHAR(255);

    define v_ATTRIBUTE_08 VARCHAR(255);

    define v_ATTRIBUTE_09 VARCHAR(255);

    define v_ATTRIBUTE_10 VARCHAR(255);

let v_skip=v_start;

let v_first=v_end- v_start;

let v_rowid_list=list{};

foreach select skip v_skip first v_first rowid into v_rowid from demo_business_trip t1 order by t1.creation_date desc

insert into table(v_rowid_list) values(v_rowid);

end foreach

let v_DEMO_BUSINESS_TRIP_list=list{};

foreach select t1.* into v_ID ,     v_USER_ID  ,     v_USER_NAME ,     v_ADDRESS  ,

    v_MATTER ,     v_LENDMONEY  ,     v_TRAFFIC ,     v_LEAVEDATE,

    v_BACKDATE,     v_SUMMARY  ,     v_ALLOWANCE  ,     v_LAST_UPDATE_DATE ,

    v_LAST_UPDATED_BY  ,     v_CREATION_DATE ,     v_CREATED_BY  ,     v_LAST_UPDATE_IP  ,     v_VERSION   ,

    v_ATTRIBUTE_01,     v_ATTRIBUTE_02,     v_ATTRIBUTE_03,

    v_ATTRIBUTE_04,     v_ATTRIBUTE_05,     v_ATTRIBUTE_06,

    v_ATTRIBUTE_07,     v_ATTRIBUTE_08,     v_ATTRIBUTE_09,     v_ATTRIBUTE_10 from demo_business_trip t1

      where t1.rowid in (select unnamed_col_1 from table(v_rowid_list))

let v_rt_DEMO_BUSINESS_TRIP=row(v_ID ,     v_USER_ID  ,     v_USER_NAME ,     v_ADDRESS  ,

    v_MATTER ,     v_LENDMONEY  ,     v_TRAFFIC ,     v_LEAVEDATE,

    v_BACKDATE,     v_SUMMARY  ,     v_ALLOWANCE  ,     v_LAST_UPDATE_DATE ,

    v_LAST_UPDATED_BY  ,     v_CREATION_DATE ,     v_CREATED_BY  ,     v_LAST_UPDATE_IP  ,     v_VERSION   ,

    v_ATTRIBUTE_01,     v_ATTRIBUTE_02,     v_ATTRIBUTE_03,

    v_ATTRIBUTE_04,     v_ATTRIBUTE_05,     v_ATTRIBUTE_06,

    v_ATTRIBUTE_07,     v_ATTRIBUTE_08,     v_ATTRIBUTE_09,     v_ATTRIBUTE_10 )::rt_DEMO_BUSINESS_TRIP;

insert into table(v_DEMO_BUSINESS_TRIP_list) values(v_rt_DEMO_BUSINESS_TRIP);

end foreach

return v_DEMO_BUSINESS_TRIP_list;

end function;

--測試 

>

select  get_list_byrowid(0,15) from dual;

Elapsed time: 0.011 sec

(expression)  LIST{ROW('8a58a6c757d1497a0157d57814d36131','test001','test001','

              testaddress','testcause',0                   ,'bus','2016-10-18 0

              0:00:00.00000','2016-10-18 00:00:00.00000','testsummary20161018 0

              94608.039',100.00            ,'2016-10-18 09:46:39.00000','8a58a6

              c754b89f150154dc1ba1c900ff','2016-10-18 09:46:39.00000','8a58a6c7

              54b89f150154dc1ba1c900ff','10.216.38.224',0                   ,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d

              1497a0157d57ce4d566cd','test001','test001','testaddress','testcau

              se',0                   ,'bus','2016-10-18 00:00:00.00000','2016-

              10-18 00:00:00.00000','testsummary20161018 095120.551',100.00    

                      ,'2016-10-18 09:51:54.00000','8a58a6c754b89f150154dc1ba1c

              900ff','2016-10-18 09:51:54.00000','8a58a6c754b89f150154dc1ba1c90

              0ff','10.216.38.225',0                   ,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d598347042c3

              ','test001','test001','testaddress','testcause',0                

                 ,'bus','2016-10-18 00:00:00.00000','2016-10-18 00:00:00.00000'

              ,'testsummary20161018 102100.749',100.00            ,'2016-10-18 

              10:21:44.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10-18 10

              :21:44.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38.222',

              0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL

              ,NULL),ROW('8a58a6c757d1497a0157d57ce40f66b8','test001','test001'

              ,'testaddress','testcause',0                   ,'bus','2016-10-18

               00:00:00.00000','2016-10-18 00:00:00.00000','testsummary20161018

               095125.096',100.00            ,'2016-10-18 09:51:54.00000','8a58

              a6c754b89f150154dc1ba1c900ff','2016-10-18 09:51:54.00000','8a58a6

              c754b89f150154dc1ba1c900ff','10.216.38.224',0                   ,

              NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c75

              7d1497a0157d58356066a89','test001','test001','testaddress','testc

              ause',0                   ,'bus','2016-10-18 00:00:00.00000','201

              6-10-18 00:00:00.00000','testsummary20161018 095820.652',100.00  

                        ,'2016-10-18 09:58:56.00000','8a58a6c754b89f150154dc1ba

              1c900ff','2016-10-18 09:58:56.00000','8a58a6c754b89f150154dc1ba1c

              900ff','10.216.38.225',0                   ,NULL,NULL,NULL,NULL,N

              ULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c857d149c20157d578498f5a

              9b','test001','test001','testaddress','testcause',0              

                   ,'bus','2016-10-18 00:00:00.00000','2016-10-18 00:00:00.0000

              0','testsummary20161018 094543.859',100.00            ,'2016-10-1

              8 09:46:52.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10-18 

              09:46:52.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38.222

              ',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL,NULL),ROW('8a58a6c757d1497a0157d57ce3156696','test001','test00

              1','testaddress','testcause',0                   ,'bus','2016-10-

              18 00:00:00.00000','2016-10-18 00:00:00.00000','testsummary201610

              18 095117.577',100.00            ,'2016-10-18 09:51:54.00000','8a

              58a6c754b89f150154dc1ba1c900ff','2016-10-18 09:51:54.00000','8a58

              a6c754b89f150154dc1ba1c900ff','10.216.38.225',0                  

               ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c

              857d149c20157d5691175507e','test001','test001','testaddress','tes

              tcause',0                   ,'bus','2016-10-18 00:00:00.00000','2

              016-10-18 00:00:00.00000','testsummary20161018 092709.986',100.00

                          ,'2016-10-18 09:30:15.00000','8a58a6c754b89f150154dc1

              ba1c900ff','2016-10-18 09:30:15.00000','8a58a6c754b89f150154dc1ba

              1c900ff','10.216.38.222',0                   ,NULL,NULL,NULL,NULL

              ,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d578153c

              6144','test001','test001','testaddress','testcause',0            

                     ,'bus','2016-10-18 00:00:00.00000','2016-10-18 00:00:00.00

              000','testsummary20161018 094525.182',100.00            ,'2016-10

              -18 09:46:39.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10-1

              8 09:46:39.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38.2

              24',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

              NULL,NULL),ROW('8a58a6c757d1497a0157d57ce7976724','test001','test

              001','testaddress','testcause',0                   ,'bus','2016-1

              0-18 00:00:00.00000','2016-10-18 00:00:00.00000','testsummary2016

              1018 095143.157',100.00            ,'2016-10-18 09:51:55.00000','

              8a58a6c754b89f150154dc1ba1c900ff','2016-10-18 09:51:55.00000','8a

              58a6c754b89f150154dc1ba1c900ff','10.216.38.222',0                

                 ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a

              6c857d149c20157d5690be44ffd','test001','test001','testaddress','t

              estcause',0                   ,'bus','2016-10-18 00:00:00.00000',

              '2016-10-18 00:00:00.00000','testsummary20161018 092759.376',100.

              00            ,'2016-10-18 09:30:13.00000','8a58a6c754b89f150154d

              c1ba1c900ff','2016-10-18 09:30:13.00000','8a58a6c754b89f150154dc1

              ba1c900ff','10.216.38.224',0                   ,NULL,NULL,NULL,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d58355

              7b6a79','test001','test001','testaddress','testcause',0          

                       ,'bus','2016-10-18 00:00:00.00000','2016-10-18 00:00:00.

              00000','testsummary20161018 095821.182',100.00            ,'2016-

              10-18 09:58:56.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10

              -18 09:58:56.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38

              .222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL),ROW('8a58a6c757d1497a0157d5a1651b44ff','test001','te

              st001','testaddress','testcause',0                   ,'bus','2016

              -10-18 00:00:00.00000','2016-10-18 00:00:00.00000','testsummary20

              161018 103103.617',100.00            ,'2016-10-18 10:31:46.00000'

              ,'8a58a6c754b89f150154dc1ba1c900ff','2016-10-18 10:31:46.00000','

              8a58a6c754b89f150154dc1ba1c900ff','10.216.38.222',0              

                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a5

              8a6c757d1497a0157d5a166e84547','test001','test001','testaddress',

              'testcause',0                   ,'bus','2016-10-18 00:00:00.00000

              ','2016-10-18 00:00:00.00000','testsummary20161018 103108.254',10

              0.00            ,'2016-10-18 10:31:47.00000','8a58a6c754b89f15015

              4dc1ba1c900ff','2016-10-18 10:31:47.00000','8a58a6c754b89f150154d

              c1ba1c900ff','10.216.38.224',0                   ,NULL,NULL,NULL,

              NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d578

              17d8617a','test001','test001','testaddress','testcause',0        

                         ,'bus','2016-10-18 00:00:00.00000','2016-10-18 00:00:0

              0.00000','testsummary20161018 094519.588',100.00            ,'201

              6-10-18 09:46:39.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-

              10-18 09:46:39.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.

              38.225',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N

              ULL,NULL,NULL)} 

1 row(s) retrieved.

Elapsed time: 0.079 sec

>

select  get_list_byrowid(6111115,6111130) from dual;

Elapsed time: 1.669 sec

(expression)  LIST{ROW('363E633D76743BD0E0534826D80A6073','test386','test386','

              testaddress','testcause',0                   ,'bus','2016-06-27 0

              0:00:00.00000','2016-06-27 00:00:00.00000','testsummary',100.00  

                        ,'2016-06-27 15:49:17.00000','8a58a6c754b89f150154dc1bc

              a9105c6','2016-06-27 15:49:17.00000','8a58a6c754b89f150154dc1bca9

              105c6','10.216.77.222',0                   ,NULL,NULL,NULL,NULL,N

              ULL,NULL,NULL,NULL,NULL,NULL),ROW('363E633D76753BD0E0534826D80A60

              73','test392','test392','testaddress','testcause',0              

                   ,'bus','2016-06-27 00:00:00.00000','2016-06-27 00:00:00.0000

              0','testsummary',100.00            ,'2016-06-27 15:49:17.00000','

              8a58a6c754b89f150154dc1bcb2705da','2016-06-27 15:49:17.00000','8a

              58a6c754b89f150154dc1bcb2705da','10.216.77.222',0                

                 ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E6

              33D76763BD0E0534826D80A6073','test2249','test2249','testaddress',

              'testcause',0                   ,'bus','2016-06-27 00:00:00.00000

              ','2016-06-27 00:00:00.00000','testsummary',100.00            ,'2

              016-06-27 15:49:17.00000','8a58a6c854eb04000154ec16199e28ff','201

              6-06-27 15:49:17.00000','8a58a6c854eb04000154ec16199e28ff','10.21

              6.77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL

              ,NULL,NULL,NULL),ROW('363E633D76773BD0E0534826D80A6073','test1994

              ','test1994','testaddress','testcause',0                   ,'bus'

              ,'2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00000','testsum

              mary',100.00            ,'2016-06-27 15:49:17.00000','8a58a6c854e

              b04000154ec15b6a52460','2016-06-27 15:49:17.00000','8a58a6c854eb0

              4000154ec15b6a52460','10.216.77.222',0                   ,NULL,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E633D76783BD0

              E0534826D80A6073','test528','test528','testaddress','testcause',0

                                 ,'bus','2016-06-27 00:00:00.00000','2016-06-27

               00:00:00.00000','testsummary',100.00            ,'2016-06-27 15:

              49:17.00000','8a58a6c754b89f150154dc1bd85f07ad','2016-06-27 15:49

              :17.00000','8a58a6c754b89f150154dc1bd85f07ad','10.216.77.222',0  

                               ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL),ROW('363E633D76793BD0E0534826D80A6073','test1498','test1498',

              'testaddress','testcause',0                   ,'bus','2016-06-27 

              00:00:00.00000','2016-06-27 00:00:00.00000','testsummary',100.00 

                         ,'2016-06-27 15:49:17.00000','8a58a6c854eb04000154ec14

              d1071a9e','2016-06-27 15:49:17.00000','8a58a6c854eb04000154ec14d1

              071a9e','10.216.77.222',0                   ,NULL,NULL,NULL,NULL,

              NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E633D767A3BD0E0534826D80A6

              073','test495','test495','testaddress','testcause',0             

                    ,'bus','2016-06-27 00:00:00.00000','2016-06-27 00:00:00.000

              00','testsummary',100.00            ,'2016-06-27 15:49:17.00000',

              '8a58a6c754b89f150154dc1bd509073b','2016-06-27 15:49:17.00000','8

              a58a6c754b89f150154dc1bd509073b','10.216.77.222',0               

                  ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E

              633D767B3BD0E0534826D80A6073','test671','test671','testaddress','

              testcause',0                   ,'bus','2016-06-27 00:00:00.00000'

              ,'2016-06-27 00:00:00.00000','testsummary',100.00            ,'20

              16-06-27 15:49:17.00000','8a58a6c754b89f150154dc1be645099f','2016

              -06-27 15:49:17.00000','8a58a6c754b89f150154dc1be645099f','10.216

              .77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

              NULL,NULL,NULL),ROW('363E633D767C3BD0E0534826D80A6073','test1269'

              ,'test1269','testaddress','testcause',0                   ,'bus',

              '2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00000','testsumm

              ary',100.00            ,'2016-06-27 15:49:17.00000','8a58a6c854eb

              04000154ec1462a51618','2016-06-27 15:49:17.00000','8a58a6c854eb04

              000154ec1462a51618','10.216.77.222',0                   ,NULL,NUL

              L,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E633D767D3BD0E

              0534826D80A6073','test897','test897','testaddress','testcause',0 

                                ,'bus','2016-06-27 00:00:00.00000','2016-06-27 

              00:00:00.00000','testsummary',100.00            ,'2016-06-27 15:4

              9:17.00000','8a58a6c754e6a7810154e6f1d58a11be','2016-06-27 15:49:

              17.00000','8a58a6c754e6a7810154e6f1d58a11be','10.216.77.222',0   

                              ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L),ROW('363E633D767E3BD0E0534826D80A6073','test369','test369','te

              staddress','testcause',0                   ,'bus','2016-06-27 00:

              00:00.00000','2016-06-27 00:00:00.00000','testsummary',100.00    

                      ,'2016-06-27 15:49:17.00000','8a58a6c754b89f150154dc1bc8b

              8058b','2016-06-27 15:49:17.00000','8a58a6c754b89f150154dc1bc8b80

              58b','10.216.77.222',0                   ,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL,NULL,NULL,NULL),ROW('363E633D767F3BD0E0534826D80A6073

              ','test897','test897','testaddress','testcause',0                

                 ,'bus','2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00000'

              ,'testsummary',100.00            ,'2016-06-27 15:49:17.00000','8a

              58a6c754e6a7810154e6f1d58a11be','2016-06-27 15:49:17.00000','8a58

              a6c754e6a7810154e6f1d58a11be','10.216.77.222',0                  

               ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E633

              D76803BD0E0534826D80A6073','test384','test384','testaddress','tes

              tcause',0                   ,'bus','2016-06-27 00:00:00.00000','2

              016-06-27 00:00:00.00000','testsummary',100.00            ,'2016-

              06-27 15:49:17.00000','8a58a6c754b89f150154dc1bca5d05be','2016-06

              -27 15:49:17.00000','8a58a6c754b89f150154dc1bca5d05be','10.216.77

              .222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL),ROW('363E633D76813BD0E0534826D80A6073','test1025','t

              est1025','testaddress','testcause',0                   ,'bus','20

              16-06-27 00:00:00.00000','2016-06-27 00:00:00.00000','testsummary

              ',100.00            ,'2016-06-27 15:49:17.00000','8a58a6c854eb040

              00154ec13ec2f1171','2016-06-27 15:49:17.00000','8a58a6c854eb04000

              154ec13ec2f1171','10.216.77.222',0                   ,NULL,NULL,N

              ULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E633D76823BD0E053

              4826D80A6073','test2339','test2339','testaddress','testcause',0  

                               ,'bus','2016-06-27 00:00:00.00000','2016-06-27 0

              0:00:00.00000','testsummary',100.00            ,'2016-06-27 15:49

              :17.00000','8a58a6c854eb04000154ec163c642aa6','2016-06-27 15:49:1

              7.00000','8a58a6c854eb04000154ec163c642aa6','10.216.77.222',0    

                             ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL

              )} 

1 row(s) retrieved.

Elapsed time: 1.984 sec

> select  get_list_byrowid(5111115,5111130) from dual;

Elapsed time: 1.405 sec

(expression)  LIST{ROW('363E634CB8373BD0E0534826D80A6073','test2183','test2183'

              ,'testaddress','testcause',0                   ,'bus','2016-06-27

               00:00:00.00000','2016-06-27 00:00:00.00000','testsummary',100.00

                          ,'2016-06-27 15:59:44.00000','8a58a6c854eb04000154ec1

              5fffb27c9','2016-06-27 15:59:44.00000','8a58a6c854eb04000154ec15f

              ffb27c9','10.216.77.222',0                   ,NULL,NULL,NULL,NULL

              ,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E634CB8383BD0E0534826D80A

              6073','test1066','test1066','testaddress','testcause',0          

                       ,'bus','2016-06-27 00:00:00.00000','2016-06-27 00:00:00.

              00000','testsummary',100.00            ,'2016-06-27 15:59:44.0000

              0','8a58a6c854eb04000154ec14001b1214','2016-06-27 15:59:44.00000'

              ,'8a58a6c854eb04000154ec14001b1214','10.216.77.222',0            

                     ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('3

              63E634CB8393BD0E0534826D80A6073','test476','test476','testaddress

              ','testcause',0                   ,'bus','2016-06-27 00:00:00.000

              00','2016-06-27 00:00:00.00000','testsummary',100.00            ,

              '2016-06-27 15:59:44.00000','8a58a6c754b89f150154dc1bd34f06fc','2

              016-06-27 15:59:44.00000','8a58a6c754b89f150154dc1bd34f06fc','10.

              216.77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL,NULL,NULL,NULL),ROW('363E634CB83A3BD0E0534826D80A6073','test93

              9','test939','testaddress','testcause',0                   ,'bus'

              ,'2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00000','testsum

              mary',100.00            ,'2016-06-27 15:59:44.00000','8a58a6c754e

              6a7810154e6f1d9a41250','2016-06-27 15:59:44.00000','8a58a6c754e6a

              7810154e6f1d9a41250','10.216.77.222',0                   ,NULL,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E634CB83B3BD0

              E0534826D80A6073','test1373','test1373','testaddress','testcause'

              ,0                   ,'bus','2016-06-27 00:00:00.00000','2016-06-

              27 00:00:00.00000','testsummary',100.00            ,'2016-06-27 1

              5:59:44.00000','8a58a6c854eb04000154ec1494b21828','2016-06-27 15:

              59:44.00000','8a58a6c854eb04000154ec1494b21828','10.216.77.222',0

                                 ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

              NULL),ROW('363E634CB83C3BD0E0534826D80A6073','test307','test307',

              'testaddress','testcause',0                   ,'bus','2016-06-27 

              00:00:00.00000','2016-06-27 00:00:00.00000','testsummary',100.00 

                         ,'2016-06-27 15:59:44.00000','8a58a6c754b89f150154dc1b

              c29604b5','2016-06-27 15:59:44.00000','8a58a6c754b89f150154dc1bc2

              9604b5','10.216.77.222',0                   ,NULL,NULL,NULL,NULL,

              NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E634CB83D3BD0E0534826D80A6

              073','test162','test162','testaddress','testcause',0             

                    ,'bus','2016-06-27 00:00:00.00000','2016-06-27 00:00:00.000

              00','testsummary',100.00            ,'2016-06-27 15:59:44.00000',

              '8a58a6c754b89f150154dc1bb3cd02e2','2016-06-27 15:59:44.00000','8

              a58a6c754b89f150154dc1bb3cd02e2','10.216.77.222',0               

                  ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E

              634CB83E3BD0E0534826D80A6073','test924','test924','testaddress','

              testcause',0                   ,'bus','2016-06-27 00:00:00.00000'

              ,'2016-06-27 00:00:00.00000','testsummary',100.00            ,'20

              16-06-27 15:59:44.00000','8a58a6c754e6a7810154e6f1d7fa121a','2016

              -06-27 15:59:44.00000','8a58a6c754e6a7810154e6f1d7fa121a','10.216

              .77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

              NULL,NULL,NULL),ROW('363E634CB83F3BD0E0534826D80A6073','test1050'

              ,'test1050','testaddress','testcause',0                   ,'bus',

              '2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00000','testsumm

              ary',100.00            ,'2016-06-27 15:59:44.00000','8a58a6c854eb

              04000154ec13f84a11c7','2016-06-27 15:59:44.00000','8a58a6c854eb04

              000154ec13f84a11c7','10.216.77.222',0                   ,NULL,NUL

              L,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E634CB8403BD0E

              0534826D80A6073','test423','test423','testaddress','testcause',0 

                                ,'bus','2016-06-27 00:00:00.00000','2016-06-27 

              00:00:00.00000','testsummary',100.00            ,'2016-06-27 15:5

              9:44.00000','8a58a6c754b89f150154dc1bce280645','2016-06-27 15:59:

              44.00000','8a58a6c754b89f150154dc1bce280645','10.216.77.222',0   

                              ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L),ROW('363E634CB8413BD0E0534826D80A6073','test1174','test1174','

              testaddress','testcause',0                   ,'bus','2016-06-27 0

              0:00:00.00000','2016-06-27 00:00:00.00000','testsummary',100.00  

                        ,'2016-06-27 15:59:44.00000','8a58a6c854eb04000154ec143

              4af1433','2016-06-27 15:59:44.00000','8a58a6c854eb04000154ec1434a

              f1433','10.216.77.222',0                   ,NULL,NULL,NULL,NULL,N

              ULL,NULL,NULL,NULL,NULL,NULL),ROW('363E634CB8423BD0E0534826D80A60

              73','test1770','test1770','testaddress','testcause',0            

                     ,'bus','2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00

              000','testsummary',100.00            ,'2016-06-27 15:59:44.00000'

              ,'8a58a6c854eb04000154ec1555502010','2016-06-27 15:59:44.00000','

              8a58a6c854eb04000154ec1555502010','10.216.77.222',0              

                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363

              E634CB8433BD0E0534826D80A6073','test2225','test2225','testaddress

              ','testcause',0                   ,'bus','2016-06-27 00:00:00.000

              00','2016-06-27 00:00:00.00000','testsummary',100.00            ,

              '2016-06-27 15:59:44.00000','8a58a6c854eb04000154ec161044288f','2

              016-06-27 15:59:44.00000','8a58a6c854eb04000154ec161044288f','10.

              216.77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL,NULL,NULL,NULL),ROW('363E634CB8443BD0E0534826D80A6073','test50

              0','test500','testaddress','testcause',0                   ,'bus'

              ,'2016-06-27 00:00:00.00000','2016-06-27 00:00:00.00000','testsum

              mary',100.00            ,'2016-06-27 15:59:44.00000','8a58a6c754b

              89f150154dc1bd57e074d','2016-06-27 15:59:44.00000','8a58a6c754b89

              f150154dc1bd57e074d','10.216.77.222',0                   ,NULL,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('363E634CB8453BD0

              E0534826D80A6073','test1630','test1630','testaddress','testcause'

              ,0                   ,'bus','2016-06-27 00:00:00.00000','2016-06-

              27 00:00:00.00000','testsummary',100.00            ,'2016-06-27 1

              5:59:44.00000','8a58a6c854eb04000154ec1511d41d3a','2016-06-27 15:

              59:44.00000','8a58a6c854eb04000154ec1511d41d3a','10.216.77.222',0

                                 ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

              NULL)} 

1 row(s) retrieved.

Elapsed time: 1.676 sec

>

 select  get_list_byrowid(50,65) from dual;

Elapsed time: 0.011 sec

(expression)  LIST{ROW('8a58a6c857d149c20157d1cf037036dc','test001','test001','

              testaddress','testcause',0                   ,'bus','2016-10-17 0

              0:00:00.00000','2016-10-17 00:00:00.00000','testsummary20161017 1

              64111.546',100.00            ,'2016-10-17 16:43:07.00000','8a58a6

              c754b89f150154dc1ba1c900ff','2016-10-17 16:43:07.00000','8a58a6c7

              54b89f150154dc1ba1c900ff','10.216.38.222',0                   ,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d

              1497a0157d1bfe8823047','test001','test001','testaddress','testcau

              se',0                   ,'bus','2016-10-17 00:00:00.00000','2016-

              10-17 00:00:00.00000','testsummary20161017 162351.339',100.00    

                      ,'2016-10-17 16:26:37.00000','8a58a6c754b89f150154dc1ba1c

              900ff','2016-10-17 16:26:37.00000','8a58a6c754b89f150154dc1ba1c90

              0ff','10.216.38.225',0                   ,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c857d149c20157d1c00f0b2cbd

              ','test001','test001','testaddress','testcause',0                

                 ,'bus','2016-10-17 00:00:00.00000','2016-10-17 00:00:00.00000'

              ,'testsummary20161017 162349.379',100.00            ,'2016-10-17 

              16:26:47.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10-17 16

              :26:47.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38.225',

              0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL

              ,NULL),ROW('8a58a6c757d1497a0157d1ced9833a2b','test001','test001'

              ,'testaddress','testcause',0                   ,'bus','2016-10-17

               00:00:00.00000','2016-10-17 00:00:00.00000','testsummary20161017

               164222.409',100.00            ,'2016-10-17 16:42:56.00000','8a58

              a6c754b89f150154dc1ba1c900ff','2016-10-17 16:42:56.00000','8a58a6

              c754b89f150154dc1ba1c900ff','10.216.38.224',0                   ,

              NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c85

              7d149c20157d1c014982d3d','test001','test001','testaddress','testc

              ause',0                   ,'bus','2016-10-17 00:00:00.00000','201

              6-10-17 00:00:00.00000','testsummary20161017 162353.611',100.00  

                        ,'2016-10-17 16:26:48.00000','8a58a6c754b89f150154dc1ba

              1c900ff','2016-10-17 16:26:48.00000','8a58a6c754b89f150154dc1ba1c

              900ff','10.216.38.225',0                   ,NULL,NULL,NULL,NULL,N

              ULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d1ced73539

              de','test001','test001','testaddress','testcause',0              

                   ,'bus','2016-10-17 00:00:00.00000','2016-10-17 00:00:00.0000

              0','testsummary20161017 164136.216',100.00            ,'2016-10-1

              7 16:42:56.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10-17 

              16:42:56.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38.224

              ',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL,NULL),ROW('8a58a6c757d1497a0157d1ced84739ff','test001','test00

              1','testaddress','testcause',0                   ,'bus','2016-10-

              17 00:00:00.00000','2016-10-17 00:00:00.00000','testsummary201610

              17 164056.172',100.00            ,'2016-10-17 16:42:56.00000','8a

              58a6c754b89f150154dc1ba1c900ff','2016-10-17 16:42:56.00000','8a58

              a6c754b89f150154dc1ba1c900ff','10.216.38.224',0                  

               ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c

              757d1497a0157d1ceda673a4d','test001','test001','testaddress','tes

              tcause',0                   ,'bus','2016-10-17 00:00:00.00000','2

              016-10-17 00:00:00.00000','testsummary20161017 164007.588',100.00

                          ,'2016-10-17 16:42:57.00000','8a58a6c754b89f150154dc1

              ba1c900ff','2016-10-17 16:42:57.00000','8a58a6c754b89f150154dc1ba

              1c900ff','10.216.38.225',0                   ,NULL,NULL,NULL,NULL

              ,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d1cee2db

              3b61','test001','test001','testaddress','testcause',0            

                     ,'bus','2016-10-17 00:00:00.00000','2016-10-17 00:00:00.00

              000','testsummary20161017 164011.914',100.00            ,'2016-10

              -17 16:42:59.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10-1

              7 16:42:59.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38.2

              25',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

              NULL,NULL),ROW('8a58a6c757d1497a0157d1cedb263a60','test001','test

              001','testaddress','testcause',0                   ,'bus','2016-1

              0-17 00:00:00.00000','2016-10-17 00:00:00.00000','testsummary2016

              1017 164011.793',100.00            ,'2016-10-17 16:42:57.00000','

              8a58a6c754b89f150154dc1ba1c900ff','2016-10-17 16:42:57.00000','8a

              58a6c754b89f150154dc1ba1c900ff','10.216.38.225',0                

                 ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a

              6c757d1497a0157d1ced09c3953','test001','test001','testaddress','t

              estcause',0                   ,'bus','2016-10-17 00:00:00.00000',

              '2016-10-17 00:00:00.00000','testsummary20161017 164005.227',100.

              00            ,'2016-10-17 16:42:54.00000','8a58a6c754b89f150154d

              c1ba1c900ff','2016-10-17 16:42:54.00000','8a58a6c754b89f150154dc1

              ba1c900ff','10.216.38.222',0                   ,NULL,NULL,NULL,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d1ced9

              ee3a3f','test001','test001','testaddress','testcause',0          

                       ,'bus','2016-10-17 00:00:00.00000','2016-10-17 00:00:00.

              00000','testsummary20161017 164050.525',100.00            ,'2016-

              10-17 16:42:56.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-10

              -17 16:42:56.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.38

              .222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL),ROW('8a58a6c857d149c20157d1c00fa42cce','test001','te

              st001','testaddress','testcause',0                   ,'bus','2016

              -10-17 00:00:00.00000','2016-10-17 00:00:00.00000','testsummary20

              161017 162413.435',100.00            ,'2016-10-17 16:26:47.00000'

              ,'8a58a6c754b89f150154dc1ba1c900ff','2016-10-17 16:26:47.00000','

              8a58a6c754b89f150154dc1ba1c900ff','10.216.38.222',0              

                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a5

              8a6c757d1497a0157d1cedffd3ade','test001','test001','testaddress',

              'testcause',0                   ,'bus','2016-10-17 00:00:00.00000

              ','2016-10-17 00:00:00.00000','testsummary20161017 164219.749',10

              0.00            ,'2016-10-17 16:42:58.00000','8a58a6c754b89f15015

              4dc1ba1c900ff','2016-10-17 16:42:58.00000','8a58a6c754b89f150154d

              c1ba1c900ff','10.216.38.224',0                   ,NULL,NULL,NULL,

              NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c757d1497a0157d1ce

              d9c53a3c','test001','test001','testaddress','testcause',0        

                         ,'bus','2016-10-17 00:00:00.00000','2016-10-17 00:00:0

              0.00000','testsummary20161017 164138.903',100.00            ,'201

              6-10-17 16:42:56.00000','8a58a6c754b89f150154dc1ba1c900ff','2016-

              10-17 16:42:56.00000','8a58a6c754b89f150154dc1ba1c900ff','10.216.

              38.224',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N

              ULL,NULL,NULL)} 

1 row(s) retrieved.

Elapsed time: 0.078 sec

>  select  get_list_byrowid(6200036,6200051) from dual;

Elapsed time: 1.689 sec

(expression)  LIST{ROW('8a58a6c7557b459501557d6131b16b63','test1957','test1957'

              ,'testaddress','testcause',0                   ,'bus','2016-06-23

               00:00:00.00000','2016-06-23 00:00:00.00000','testsummary',100.00

                          ,'2016-06-23 21:09:29.00000','8a58a6c854eb04000154ec1

              5d28e25ad','2016-06-23 21:09:29.00000','8a58a6c854eb04000154ec15d

              28e25ad','10.216.77.222',0                   ,NULL,NULL,NULL,NULL

              ,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b459501557d6135ba

              6b7a','test2489','test2489','testaddress','testcause',0          

                       ,'bus','2016-06-23 00:00:00.00000','2016-06-23 00:00:00.

              00000','testsummary',100.00            ,'2016-06-23 21:09:30.0000

              0','8a58a6c854eb04000154ec150be21cfe','2016-06-23 21:09:30.00000'

              ,'8a58a6c854eb04000154ec150be21cfe','10.216.77.222',0            

                     ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8

              a58a6c7557b459501557d612d846b09','test904','test904','testaddress

              ','testcause',0                   ,'bus','2016-06-23 00:00:00.000

              00','2016-06-23 00:00:00.00000','testsummary',100.00            ,

              '2016-06-23 21:09:28.00000','8a58a6c754b89f150154dc1bca2a05b7','2

              016-06-23 21:09:28.00000','8a58a6c754b89f150154dc1bca2a05b7','10.

              216.77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL,NULL,NULL,NULL),ROW('8a58a6c7557b459501557d6127ec6aa7','test15

              70','test1570','testaddress','testcause',0                   ,'bu

              s','2016-06-23 00:00:00.00000','2016-06-23 00:00:00.00000','tests

              ummary',100.00            ,'2016-06-23 21:09:27.00000','8a58a6c85

              4eb04000154ec1439f21469','2016-06-23 21:09:27.00000','8a58a6c854e

              b04000154ec1439f21469','10.216.77.222',0                   ,NULL,

              NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b45

              9501557d612c8f6b03','test2108','test2108','testaddress','testcaus

              e',0                   ,'bus','2016-06-23 00:00:00.00000','2016-0

              6-23 00:00:00.00000','testsummary',100.00            ,'2016-06-23

               21:09:28.00000','8a58a6c754e6a7810154e6f1d7b3120f','2016-06-23 2

              1:09:28.00000','8a58a6c754e6a7810154e6f1d7b3120f','10.216.77.222'

              ,0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L,NULL),ROW('8a58a6c7557b459501557d6130166b19','test1752','test17

              52','testaddress','testcause',0                   ,'bus','2016-06

              -23 00:00:00.00000','2016-06-23 00:00:00.00000','testsummary',100

              .00            ,'2016-06-23 21:09:29.00000','8a58a6c854eb04000154

              ec16161d28d4','2016-06-23 21:09:29.00000','8a58a6c854eb04000154ec

              16161d28d4','10.216.77.222',0                   ,NULL,NULL,NULL,N

              ULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b459501557d613

              3ca6b6e','test783','test783','testaddress','testcause',0         

                        ,'bus','2016-06-23 00:00:00.00000','2016-06-23 00:00:00

              .00000','testsummary',100.00            ,'2016-06-23 21:09:30.000

              00','8a58a6c854eb04000154ec1484621781','2016-06-23 21:09:30.00000

              ','8a58a6c854eb04000154ec1484621781','10.216.77.222',0           

                      ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('

              8a58a6c7557b459501557d61368a6b80','test2275','test2275','testaddr

              ess','testcause',0                   ,'bus','2016-06-23 00:00:00.

              00000','2016-06-23 00:00:00.00000','testsummary',100.00          

                ,'2016-06-23 21:09:30.00000','8a58a6c854eb04000154ec1403b31234'

              ,'2016-06-23 21:09:30.00000','8a58a6c854eb04000154ec1403b31234','

              10.216.77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NULL

              ,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b459501557d612d916b0a','tes

              t2285','test2285','testaddress','testcause',0                   ,

              'bus','2016-06-23 00:00:00.00000','2016-06-23 00:00:00.00000','te

              stsummary',100.00            ,'2016-06-23 21:09:28.00000','8a58a6

              c854eb04000154ec15e5922691','2016-06-23 21:09:28.00000','8a58a6c8

              54eb04000154ec15e5922691','10.216.77.222',0                   ,NU

              LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c7557

              b459501557d6128c76aae','test676','test676','testaddress','testcau

              se',0                   ,'bus','2016-06-23 00:00:00.00000','2016-

              06-23 00:00:00.00000','testsummary',100.00            ,'2016-06-2

              3 21:09:27.00000','8a58a6c854eb04000154ec15e3ff267b','2016-06-23 

              21:09:27.00000','8a58a6c854eb04000154ec15e3ff267b','10.216.77.222

              ',0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU

              LL,NULL),ROW('8a58a6c7557b459501557d612bf36b01','test1049','test1

              049','testaddress','testcause',0                   ,'bus','2016-0

              6-23 00:00:00.00000','2016-06-23 00:00:00.00000','testsummary',10

              0.00            ,'2016-06-23 21:09:28.00000','8a58a6c854eb0400015

              4ec14dda51b17','2016-06-23 21:09:28.00000','8a58a6c854eb04000154e

              c14dda51b17','10.216.77.222',0                   ,NULL,NULL,NULL,

              NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b459501557d61

              34226b71','test201','test201','testaddress','testcause',0        

                         ,'bus','2016-06-23 00:00:00.00000','2016-06-23 00:00:0

              0.00000','testsummary',100.00            ,'2016-06-23 21:09:30.00

              000','8a58a6c854eb04000154ec164d8c2b7e','2016-06-23 21:09:30.0000

              0','8a58a6c854eb04000154ec164d8c2b7e','10.216.77.222',0          

                       ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW(

              '8a58a6c7557b459501557d6130a36b5d','test2282','test2282','testadd

              ress','testcause',0                   ,'bus','2016-06-23 00:00:00

              .00000','2016-06-23 00:00:00.00000','testsummary',100.00         

                 ,'2016-06-23 21:09:29.00000','8a58a6c754b89f150154dc1bb39602dc

              ','2016-06-23 21:09:29.00000','8a58a6c754b89f150154dc1bb39602dc',

              '10.216.77.222',0                   ,NULL,NULL,NULL,NULL,NULL,NUL

              L,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b459501557d6130956b5c','te

              st887','test887','testaddress','testcause',0                   ,'

              bus','2016-06-23 00:00:00.00000','2016-06-23 00:00:00.00000','tes

              tsummary',100.00            ,'2016-06-23 21:09:29.00000','8a58a6c

              854eb04000154ec15454b1f61','2016-06-23 21:09:29.00000','8a58a6c85

              4eb04000154ec15454b1f61','10.216.77.222',0                   ,NUL

              L,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),ROW('8a58a6c7557b

              459501557d61357a6b77','test194','test194','testaddress','testcaus

              e',0                   ,'bus','2016-06-23 00:00:00.00000','2016-0

              6-23 00:00:00.00000','testsummary',100.00            ,'2016-06-23

               21:09:30.00000','8a58a6c854eb04000154ec151dd01dc0','2016-06-23 2

              1:09:30.00000','8a58a6c854eb04000154ec151dd01dc0','10.216.77.222'

              ,0                   ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL

              L,NULL)} 

1 row(s) retrieved.

Elapsed time: 2.012 sec

5 測試使用主鍵

> select skip 6111115 first 15 rowid from demo_business_trip t1 order by t1.creation_date desc;

      rowid 

    1582595

    1582596

    1582597

    1582598

    1582599

    1582600

    1582601

    1582602

    1582603

    1582604

    1582605

    1582606

    1582607

    1582608

    1582609

15 row(s) retrieved.

Elapsed time: 1.667 sec

> select skip 6111115 first 15 id from demo_business_trip t1 order by t1.creation_date desc;

id                                                 

363E633D76743BD0E0534826D80A6073                  

363E633D76753BD0E0534826D80A6073                  

363E633D76763BD0E0534826D80A6073                  

363E633D76773BD0E0534826D80A6073                  

363E633D76783BD0E0534826D80A6073                  

363E633D76793BD0E0534826D80A6073                  

363E633D767A3BD0E0534826D80A6073                  

363E633D767B3BD0E0534826D80A6073                  

363E633D767C3BD0E0534826D80A6073                  

363E633D767D3BD0E0534826D80A6073                  

363E633D767E3BD0E0534826D80A6073                  

363E633D767F3BD0E0534826D80A6073                  

363E633D76803BD0E0534826D80A6073                  

363E633D76813BD0E0534826D80A6073                  

363E633D76823BD0E0534826D80A6073                  

15 row(s) retrieved.

Elapsed time: 7.548 sec

下面的SQL 語句不合法

1 select * from t1 where rowid in(

select skip 0 first 15 rowid  from t1  order by table_name desc);

  201: A syntax error has occurred.

Error in line 2

Near character position 39

2  select * from t1 where rowid in(

select skip 0 first 15 rowid  from t1  );

   944: Cannot use "first", "limit" or "skip" in this context.

Error in line 2

Near character position 38

3   select * from t1 where rowid in(

select  rowid  from t1  order by table_name desc);

  201: A syntax error has occurred.

Error in line 2

Near character position 24