Alter table add comment oracle

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 vote254 views1 answer
Increase speed of like queries postgres
SQL
1 vote260 views4 answers
Psql check tables command
SQL
0 vote261 views1 answer
Drop index in sql
SQL
4 votes254 views1 answer
Force drop all tables postgres
SQL
2 votes240 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
4 votes397 views6 answers
Laravel jwt
SQL
0 vote245 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote264 views1 answer
Varchar2 length in oracle
SQL
1 vote266 views7 answers
Filter
SQL
0 vote261 views1 answer
How to add unique key constraint in mysql
SQL