Shulou(Shulou.com)06/01 Report--

Step 1: get the physical address of the data

Step 2: get the maximum number of pages

Step 3: get the minimum number of pages

Step 4: because the number of pages obtained are all physical addresses, then query the specific data according to the physical address

-- rowid pagination, the first step

Select rowid rid,OWNER,OBJECT_NAME,LAST_DDL_TIME from tt order by LAST_DDL_TIME desc

RID OWNER OBJECT_NAME LAST_DDL_TIME

-

AAAVciAABAAAXEZAAC SYS CON$ 2013-08-24 11:52:40

AAAVciAABAAAXEZAAA SYS ICOL$ 2013-08-24 11:47:37

AAAVciAABAAAXEZAAE SYS C_COBJ# 2013-08-24 11:37:35

AAAVciAABAAAXEZAAF SYS I_OBJ# 2013-08-24 11:37:35

AAAVciAABAAAXEZAAG SYS PROXY_ROLE_DATA$ 2013-08-24 11:37:35

AAAVciAABAAAXEZAAH SYS I_IND1 2013-08-24 11:37:35

AAAVciAABAAAXEZAAI SYS I_CDEF2 2013-08-24 11:37:35

AAAVciAABAAAXEZAAJ SYS I_OBJ5 2013-08-24 11:37:35

AAAVciAABAAAXEZAAK SYS I_PROXY_ROLE_DATA$_1 2013-08-24 11:37:35

AAAVciAABAAAXEZAAL SYS FILE$ 2013-08-24 11:37:35

AAAVciAABAAAXEZAAM SYS UET$ 2013-08-24 11:37:35

AAAVciAABAAAXEZAAN SYS I_FILE#_BLOCK# 2013-08-24 11:37:35

AAAVciAABAAAXEZAAO SYS I_FILE1 2013-08-24 11:37:35

AAAVciAABAAAXEZAAP SYS I_CON1 2013-08-24 11:37:35

AAAVciAABAAAXEZAAQ SYS I_OBJ3 2013-08-24 11:37:35

AAAVciAABAAAXEZAAR SYS I_TS# 2013-08-24 11:37:35

AAAVciAABAAAXEZAAD SYS UNDO$ 2013-08-24 11:37:35

AAAVciAABAAAXEZAAS SYS I_CDEF4 2013-08-24 11:37:35

AAAVciAABAAAXEZAAB SYS I_USER1 2013-08-24 11:37:35

19 rows selected.

-- rowid pagination, step 2

Select rownum rn,rid from (select rowid rid,OWNER,OBJECT_NAME,LAST_DDL_TIME from tt order by LAST_DDL_TIME desc) where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.