Alter table add comment oracle

COMMENT ON TABLE table_name IS 'A table comment';
COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment';

SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';

Similar codes

0 vote266 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
3 votes254 views1 answer
V$session not found in oracle
SQL
0 vote257 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote284 views1 answer
Mysql query to select the highest value
SQL
0 vote267 views1 answer
What is default mysql database password in linux
SQL
0 vote282 views1 answer
Compare two tables to find unmatched records
SQL
1 vote272 views1 answer
Postgres concat_ws
SQL
1 vote272 views1 answer
Rename table column name in mysql
SQL
0 vote278 views2 answers
Sqlite unique
SQL
4 votes291 views2 answers
Truncate oracle
SQL