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 vote166 views1 answer
Update database collation in postgresql
SQL
0 vote159 views1 answer
Sql log file inof
SQL
0 vote156 views1 answer
Add mysql database to power bi web
SQL
1 vote153 views1 answer
Blob datatype in mysql
SQL
3 votes153 views1 answer
Select sequence oracle
SQL
14 votes147 views1 answer
Sql value of string
SQL
13 votes141 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote136 views1 answer
Django how to get query result count
SQL
1 vote161 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote141 views1 answer
Tsql default value when no value returned by query
SQL