lihao312 发表于 2013-1-14 08:39:19

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;
页: [1]
查看完整版本: oracle对表的基本操作