MYSQL:
查表:
show tables;
分页:
select * from tableName limit a,b
ORACLE:
查表
select table_name from user_tables;
分页:(1)SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 8
)
WHERE RN >= 2
(2)SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
)
WHERE RN BETWEEN 21 AND 40
第一种效率高