1.怎么用DECODE,如果不让你用呢?
case when
2.过程里怎么获得一个返回值?
select into
3.过程里怎么返回结果集?
4.什么是第三范式?
5.如何减低水位?
alter tabletest_move shrinkspace;
但前提需要先运行alter tabletest_move enable row movement;,打开row movement功能
6.删除重复数据的方法(留一条)
DELETE FROM EMP E
WHERE E.ROWID > (SELECT MIN (X.ROWID)
FROM EMP X
WHERE X.EMP_NO = E.EMP_NO);
七、.删除重复数据的方法(不留)
1.临时表
create table temp nologging as
select phone from fs_family group by phone having count(1) >=2;
delete temp t where exists (select 1 from fs_family f where t.phone=f.phone);