oracle分页查询

oracle分页查询

SELECT* FROM(SELECT ROWNUM AS rowno,
	a.owner,
	a.table_name,
	c.column_name AS fk_column,
	b.owner as referenced_owner,
	b.table_name AS referenced_table,
	d.column_name
FROM
	user_constraints a,
	user_constraints b,
	user_cons_columns c,
	user_cons_columns d 
WHERE
	a.r_constraint_name = b.constraint_name 
	AND a.constraint_type = 'R' 
	AND b.constraint_type = 'P' 
	AND a.r_owner = b.owner 
	AND a.constraint_name = c.constraint_name 
	AND b.constraint_name = d.constraint_name 
	AND a.owner = c.owner 
	AND a.table_name = c.table_name 
	AND b.owner = d.owner 
	AND b.table_name = d.table_name 
	AND a.owner = 'CJUSER' 
	AND ROWNUM <= 200) t
WHERE t.ROWNO>=0