1、创建测试表,
create table test_data_1(id number, value varchar2(20));
2、插入测试数据,插入1000条记录
insert into test_data_1 select level, 'val_'||level from dual connect by level <= 1000;
commit;
3、查询test_data_1表中全量数据记录数,select count(*) from test_data_1 t;可以发现共1000条记录;
4、编写语句,从test_data_1取id在21至30之间的记录,并创建新表test_data_2;
create table test_data_2 as select * from test_data_1 where id between 21 and 30;
5、查询test_data_2表中全量数据记录数,select count(*) from test_data_2 t;可以发现共10条记录;