1.查询student表名及注释
select * from user_tab_comments where table_name = 'STUDENT'
2.查询student表所有列名及注释
select * from user_col_comments where table_name = 'STUDENT'
3.为表student添加注释信息
COMMENT ON TABLE STUDENT is '学生信息表'
4.为表student列sname添加注释信息
COMMENT ON COLUMN STUDENT.SNAME is '学生姓名'