1 创建表加注释:
create table stu_info (
sno number(3),
sname varchar2(30),
sex varchar2(4)
);
comment on column stu_info.sex is '性别';
comment on column stu_info.sname is '姓名';
comment on column stu_info.sno is 'ID';
insert into stu_info(sno, sname, sex) values(1, '瑶瑶', '女');
insert into stu_info(sno, sname, sex) values(2, '优优', '男');
insert into stu_info(sno, sname, sex) values(3, '倩倩', '女');
commit;
2 查询插入结果
select * from stu_info
SNO | SNAME | SEX |
---|---|---|
1 | 瑶瑶 | 女 |
2 | 优优 | 男 |
3 | 倩倩 | 女 |
3 查询注释
select * from user_col_comments
TABLE_NAME | COLUMN_NAME | COMMENTS |
---|---|---|
STU_INFO | S |