程序博客网 > 手机域名怎么注册

informix 分页

来源：互联网 发布：手机域名怎么注册 编辑：程序博客网 时间：2024/06/07 15:20
/***********************************************************************/
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;

/*
SET DEBUG FILE TO '/home/informix/info_debug.txt';
TRACE 'BEGIN TRACE';
trace on;
*/
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字段
/*
CREATE temp TABLE tmp_DEMO_BUSINESS_TRIP( tmp_rowid int,  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 t2.tmp_rowid,t1.* from demo_business_trip t1, t_tmp_rowid t2 where t1.rowid =t2.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);


/* 
SET DEBUG FILE TO '/home/informix/info_debug.txt';
TRACE 'BEGIN TRACE';
trace on;
*/ 
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
0 0
手机域名怎么注册 手机域名怎么注册
原创粉丝点击
热门IT博客
清茶淘宝助手充值卡清茶淘宝助手充值卡
原油api最新数据原油api最新数据
淘宝浏览app赚佣金
数据分析师薪酬待遇
php isset 属性
博雅软件集团高层
c语言中逗号运算符
传智播客淘淘网sql
caffe 样本制件
ipython在linux安装
数据库主从同步的原理
c语言调用opencv
给软件添加注册码
mysql数据库类型有哪些
h3c交换机端口加vlan
大众mirrorlink 软件
淘宝数据分析看不懂
电子商务域名
完整的数据分析报告
创维42e380s连接网络
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 北服人画室 北服专升本 自考北服 北服成人高考 2018美术生多少分能上北服 北朝论坛 坐北朝南 北朝 北朝民歌 北朝纪事 北朝汉月 北朝风云 北朝春事 北朝世兵 北朝乐府 北朝论坛app 坐北朝南什么意思 北朝民歌敕勒歌 北朝论坛首页 敕勒歌北朝民歌 北朝汉月 元祀 北朝风云 书香满室.qd 北朝世兵 石怀玉 坐北朝南的财位示意图 北朝女道 谢宁歌 坐北朝南的房子床头朝哪好 临高启明北朝论坛 坐北朝南的房子好吗 北朝乐府民歌 做北朝南的房子财位在哪 北朝春事 清明水萩 敕勒歌 北朝民歌 北朝名歌敕勒歌 坐南朝北还是坐北朝南好 楼房怎样判断坐北朝南 坐南朝北好还是坐北朝南好 北极熊 北极光 北极狐 北极 北极村

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里