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 vote200 views3 answers
Postgresql allow remote connections
SQL
0 vote189 views2 answers
Sql join on wildcard
SQL
2 votes200 views1 answer
Oracle kill job by sid
SQL
0 vote184 views1 answer
Sql get month from date
SQL
0 vote188 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote191 views1 answer
Sql string contains case sensitive
SQL
1 vote194 views1 answer
Increase date by one day in sql oracle
SQL
0 vote210 views1 answer
Create boolean column in MySQL with false as default value?
SQL
4 votes251 views4 answers
Check constraint in ms sql
SQL
0 vote219 views1 answer
How to join result table in mysql
SQL