ORACLE数据库分页查询及主键自增

1. 分页查询并排序

SELECT
	*
FROM
	(
		SELECT
			temp.*, ROWNUM RN
		FROM
			(
				SELECT
					*
				FROM
					(SELECT * FROM 表名)
				ORDER BY
					ORDER DESC
			) temp
		WHERE
			ROWNUM <=
		END (page * pagesize) 
	)
WHERE
	RN >= START (page - 1 * pagesize + 1) 

2. 分页查询不排序

SELECT
	*
FROM
	(
		SELECT
			temp.*, ROWNUM RN
		FROM
			(SELECT * FROM 表名) temp
		WHERE
			ROWNUM <=
		END (page * pagesize)
	)
WHERE
	RN >= START (page - 1 * pagesize + 1)

3. 主键自增
   1 首先创建一个序列

   CREATE SEQUENCE "用户名"."序列名" 
   MINVALUE MIN    ##最小值
   MAXVALUE MAX 	##最大值
   INCREMENT BY 1 		##步长
   START WITH 1 CACHE 20 NOORDER NOCYCLE
   

   2 插入时主键写"序列名.NEXTVAL"