转自:http://blog.sina.com.cn/s/blog_82a09f100101a7on.html
创建Oracle数据库表时候加上注释
CREATE TABLE t1(
id varchar2(32) primary key,
name VARCHAR2(8) NOT NULL,
age number,
)
添加表注释:
COMMENT ON table t1 IS '个人信息';
添加字段注释:
comment on column t1.id is 'id';
comment on column t1.nameis '姓名';
comment on column t1.age is '年龄';
查询:
select * from user_col_comments;
创建Oracle数据库表时候加上注释
CREATE TABLE t1(
id varchar2(32) primary key,
name VARCHAR2(8) NOT NULL,
age number,
)
添加表注释:
COMMENT ON table t1 IS '个人信息';
添加字段注释:
comment on column t1.id is 'id';
comment on column t1.nameis '姓名';
comment on column t1.age is '年龄';
查询:
select * from user_col_comments;