//表添加备注
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;
oracle对表的基本操作
最新推荐文章于 2022-03-08 21:32:39 发布