摘要:
删除表中多余的重复记录,重复记录是根据单个字段(Id)来判断,只留有rowid最小的记录 DELETE from _tableName WHERE (id) IN ( SELECT id FROM _tableName GROUP BY id HAVING COUNT(id) > 1) AND RO 阅读全文
摘要:
1、建用户 create user test_user identified by test_password; create user test_user identified by test_password default tablespace ts_zzg; //直接在建用户的时候就赋予表空 阅读全文