Oracle create table comment

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 vote106 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote98 views1 answer
Sql new line output
SQL
1 vote108 views3 answers
Mariadb add foreign key
SQL
3 votes114 views3 answers
Mysql order by list
SQL
0 vote135 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote158 views1 answer
Oracle temporary table
SQL
3 votes106 views1 answer
Oracle user quota unlimited
SQL
3 votes113 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote117 views1 answer
Mysql zerofill
SQL
0 vote114 views1 answer
Run sql script file and changes db name in this file using c#
SQL