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 vote347 views1 answer
Join in update query in mysql
SQL
0 vote372 views1 answer
Load data infile mariadb slow
SQL
0 vote321 views1 answer
Sql from null to not null
SQL
57 votes584 views6 answers
Mysql alter table add column
SQL
0 vote343 views1 answer
Mysql use password error
SQL
0 vote331 views1 answer
Sql server select ignore dupplicates
SQL
1 vote357 views1 answer
Sql server kill all connections
SQL
-3 votes371 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote366 views2 answers
Sql split string by space
SQL
0 vote325 views1 answer
Stuff in sql server
SQL