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 vote286 views1 answer
Mysql select random rows large table
SQL
11 votes195 views1 answer
Ddl materialized view
SQL
4 votes224 views1 answer
Oracle user tables
SQL
0 vote250 views1 answer
Mysql subtract month from timestamp
SQL
2 votes200 views3 answers
Postgresql reset auto increment
SQL
0 vote199 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote188 views1 answer
Sqlite closes value
SQL
13 votes207 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote218 views1 answer
Mysql show create db
SQL
10 votes182 views1 answer
Oracle dependency
SQL