Oracle SQL分页查询
1、表结构
SQL> desc test;
名称 是否为空? 类型
--------------------- -------- ---------------
ID NOT NULL NUMBER(8)
USERNAME VARCHAR2(32)
PASSWORD VARCHAR2(32)
AGE NUMBER(3)
BIRTHDAY DATE
ADDRESS VARCHAR2(40)
2、表记录条数
SQL> select count(*) from test;
COUNT(*)
----------
5000001
3、表中部分数据
SQL> select * from test where rownum <10;
ID USERNAME PASSWORD AGE BIRTHDAY ADDRESS
---------- ---------------------- ------------------------------ ---------