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 vote218 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote218 views1 answer
Mysql update sequence with order by
SQL
0 vote234 views1 answer
Mysql Like(searching in the string)
SQL
0 vote225 views2 answers
Mysql on update current_timestamp
SQL
1 vote219 views1 answer
Oracle list datafiles in tablespace
SQL
6 votes246 views2 answers
Psql load dump
SQL
0 vote224 views1 answer
Big table in mysql
SQL
6 votes228 views4 answers
Mysql group by month
SQL
0 vote247 views1 answer
How to find total working hour in sql
SQL
0 vote245 views1 answer
Mysql command line top 10
SQL