往tmp_test1中添加一个字段(name varchar2(10)):
alter table tmp_test1 add name varchar2(10);
修改此字段的长度,注意:如果该字段中已经有内容则不能将字段的值范围长度缩小。
alter table tmp_test1 modify name varchar2(20);
SQL> alter table tmp_test_1 modify name varchar2(200);
alter table tmp_test_1 modify name varchar2(200)
ORA-01441: column to be modified must be empty to decrease column length
删除一个字段(name字段):
SQL> alter table tmp_test_1 drop column name ;
Table altered
过滤本表中完全重复的项(假设tmp_test1只有id和name两列):
select * from tmp_test1 t1 where t1.rowid =
(select t11.rowid from tmp_test1 t11, tmp_test1 t12
where t11.rowid > t12.rowid
and t11.name = t12.name
and t11.id = t12.id)
取差集:
select t1.id, t1.name from tmp_test1 t1
minus
select t2.id, t2.name from tmp_test2 t2
取交集:
select t1.id, t1.name from tmp_test1 t1
intersect
select t2.id, t2.name from tmp_test2 t2
合并重复项:
select t1.id, t1.name from tmp_test1 t1
union
select t2.id, t2.name from tmp_test2 t2
合并所有项,包括重复的:
select t1.id, t1.name from tmp_test1 t1
union all
select t2.id, t2.name from tmp_test2 t2