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 vote143 views1 answer
Install postgresql 12 on debian 10
SQL
17 votes125 views2 answers
Mysql date to string
SQL
0 vote113 views1 answer
How to export only procedures mysql
SQL
4 votes64 views2 answers
Select todays data postgres query
SQL
0 vote108 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote120 views1 answer
How to print sql query
SQL
0 vote103 views2 answers
SQL Server Standard
SQL
0 vote158 views1 answer
How to show current database in mysql
SQL
0 vote113 views1 answer
Sql developer connect to sql server
SQL
8 votes122 views1 answer
Mac restore mysql database command line
SQL