如果a、b表原本是空表,请问执行下列语句后,以下哪个表述正确
insert into a values(1,'abc','1');
insert into a values(2,'abc','2');
create table b as select * from a;
rollback;
A a表有数据,b表没有数据
B a表b表都有两行数据
C a表没有数据,b表有数据
D a表b表都没有数据
SQL> create table a (id number,name varchar2(10),pai varchar2(2));
Table created.
SQL> insert into a values(1,'abc','1');
1 row created.
SQL> insert into a values(2,'abc','2');
1 row created.
SQL> select * from a;
ID NAME PA
---------- ---------- --
1 abc 1
2 abc 2
SQL> create table b as select * from a;
Table created.
SQL> rollback;
Rollback complete.
SQL> select * from b;
ID NAME PA
---------- ---------- --
1 abc 1
2 abc 2
SQL> select * from a;

ID NAME PA
---------- ---------- --
1 abc 1
2 abc 2