create table look.test ( id number, description varchar2(100));comment on column test.id is 'unique id'; comment on column test.description is 'description on id';
SQL> create table test 2 ( id number, 3 description varchar2(100)); Table created. SQL> comment on column test.id is 'unique id'; Comment created. SQL> comment on column test.description is 'description on id'; Comment created.SQL> select a.table_name, a.column_name, a.data_type, b.comments 2 from user_tab_columns a, user_col_comments b 3 where a.table_name = b.table_name (+) 4 and a.column_name = b.column_name (+) 5 and a.table_name = 'TEST' 6 /TABLE_NAME COLUMN_NAME ------------------------------ ------------------------------ DATA_TYPE -------------------------------------------------------------------------------- COMMENTS -------------------------------------------------------------------------------- TEST ID NUMBER unique idTEST DESCRIPTION VARCHAR2 description on id
( id number,
description varchar2(100));comment on column test.id is 'unique id';
comment on column test.description is 'description on id';
2 ( id number,
3 description varchar2(100));
Table created.
SQL> comment on column test.id is 'unique id';
Comment created.
SQL> comment on column test.description is 'description on id';
Comment created.SQL> select a.table_name, a.column_name, a.data_type, b.comments
2 from user_tab_columns a, user_col_comments b
3 where a.table_name = b.table_name (+)
4 and a.column_name = b.column_name (+)
5 and a.table_name = 'TEST'
6 /TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------
DATA_TYPE
--------------------------------------------------------------------------------
COMMENTS
--------------------------------------------------------------------------------
TEST ID
NUMBER
unique idTEST DESCRIPTION
VARCHAR2
description on id