oracle数据库学习

1. delete  from  tbm_exlips_user where user_id in ('tes','a','wu','gg1');要单引号

执行完commit

2.删除表中重复记录

delete from people where peopleId in (select peopleId from people group by peopleId having count(peopleId>1)

          and rowid not in (select min(rowid) from people group by peopleId having count(peopleId>1);