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;