oracle对表的基本操作

//表添加备注COMMENT ON TABLE userinfo IS '用户表'//字段添加备注COMMENT ON COLUMN userinfo.makedate IS '录入日期'//表添加字段ALTER TABLE test.userinfo ADD makedate DATE;//查询重复记录select code from test group by code having count(code) > 1;