---------------------------- -----------
COMMENTS
--------------------------------------------------------------------------------
FA TABLE
EMP TABLE
DEPT TABLE
deptment table
TABLE_NAME TABLE_TYPE
------------------------------ -----------
COMMENTS
--------------------------------------------------------------------------------
BONUS TABLE
SQL> comment on column dept.dname is 'aaaaaaa';
Comment created.
SQL> select * from user_col_comments where table_name='DEPT';
TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------
COMMENTS
--------------------------------------------------------------------------------
DEPT DEPTNO
DEPT DNAME
aaaaaaa
DEPT LOC
SQL> comment on column dept.dname is '';
Comment created.
|