data_input.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 62 行

delete from sm_emp_sex;
commit;
insert into sm_emp_sex values('0000000001','张飞',10000,'62652091','男');
insert into sm_emp_sex values('0000000002','关羽',10000,'62652091','男');
insert into sm_emp_sex values('0000000003','刘备',10000,'62652091','男');
insert into sm_emp_sex values('0000000007','007',100,'62652091','男');
commit;


SQL> select rowid ,empid from sm_emp_sex;

ROWID              EMPID
------------------ ----------
AAAFi6AABAAAHtzAAA 0000000001
AAAFi6AABAAAHtzAAB 0000000002
AAAFi6AABAAAHtzAAC 0000000003
AAAFi6AABAAAHtzAAD 0000000007

SQL> delete from sm_emp_sex where EMPID='0000000003';

已删除 1 行。

SQL> select rowid ,empid from sm_emp_sex;

ROWID              EMPID
------------------ ----------
AAAFi6AABAAAHtzAAA 0000000001
AAAFi6AABAAAHtzAAB 0000000002
AAAFi6AABAAAHtzAAD 0000000007

--data导出
create table temp_emp as select * from sm_emp_sex;

--
truncate table sm_emp_sex;

insert into sm_emp_sex (select * from temp_emp);

select rowid ,empid from sm_emp_sex;


ROWID              EMPID
------------------ ----------
AAAFi/AABAAAHtzAAA 0000000001
AAAFi/AABAAAHtzAAB 0000000002
AAAFi/AABAAAHtzAAC 0000000007


----空洞形成演示.是否形成，还要看dbms的分配------------------
drop table test_1;
create table test_1(name varchar(100));
insert into test_1 values('1');
insert into test_1 values('2');
insert into test_1 values('3');
insert into test_1 values('4');

select rowid ,name from test_1;

delete from test_1 where name='2';

insert into test_1 values('1234567890');
select rowid ,name from test_1;