CREATE OR REPLACE VIEW SEARCH.view_test
AS select * from TBL_NEWS_TEST_0
union all select * from TBL_NEWS_TEST_1
union all select * from TBL_NEWS_TEST_2
union all select * from TBL_NEWS_TEST_3
union all select * from TBL_NEWS_TEST_4
union all select * from TBL_NEWS_TEST_5
;
复制表结构，建立新表
create table tbl_news_test_1 as
select *
from tbl_news_spider_1
where 1=2 ;
Oracle中实现类似SQL Server中TOP100的功能
select rownum,id,linkurl from tbl_news_spider_2 where rownum<100
查询t_table表中所有记录第10到20条，按id排序。
SQL语句为：
SELECT * FROM t_table t1 WHERE (SELECT count(*) FROM t_table t2 WHERE t2.id < t1.id ) >= 10 AND (SELECT count(*) FROM t_table t2 WHERE t2.id < t1.id ) < 20
又如查询t_table表中key='123'第10到20条的记录，按id排序。
SELECT * FROM t_table t1 WHERE (SELECT count(*) FROM t_table t2 WHERE t2.id < t1.id AND t2.key = '123') >= 10 AND (SELECT count(*) FROM t_table t2 WHERE t2.id < t1.id AND t2.key = '123') < 20 AND t1.key = '123'
当然条件中的id可以换为任何能标识记录顺序的字段。