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

1 vote148 views1 answer
Select users with same username
SQL
1 vote151 views1 answer
Sql how to replace full stop
SQL
0 vote148 views1 answer
Vs 2019 connect to local mysql database
SQL
2 votes289 views1 answer
Set auto increment from 1
SQL
0 vote140 views1 answer
How to get inserted id in sql server
SQL
0 vote162 views2 answers
Drop tables from local table database postgres
SQL
25 votes152 views4 answers
Sqlserver add column
SQL
1 vote156 views1 answer
How to see which columns are indexxed mysql
SQL
3 votes146 views2 answers
Sql get month name
SQL
6 votes139 views5 answers
Mysql get last insert id
SQL