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 vote118 views1 answer
Stuff in sql server
SQL
3 votes125 views4 answers
Ubuntu stop mysql
SQL
8 votes141 views2 answers
Change name of colum in sql table
SQL
0 vote125 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote114 views2 answers
How to start postgresql laravel
SQL
0 vote137 views1 answer
If column value is null then in mysql
SQL
3 votes128 views4 answers
Show sql server database
SQL
-1 vote145 views3 answers
PS5
SQL
18 votes123 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote128 views1 answer
Sql trigger before delete
SQL