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 vote200 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote192 views1 answer
Char vs varchar2 in sql
SQL
0 vote200 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
3 votes186 views2 answers
Sql paging query
SQL
0 vote203 views1 answer
10000000000000000000 am to meters
SQL
0 vote248 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote217 views1 answer
How to run mysql on terminal mac
SQL
1 vote224 views2 answers
Drop table with constraints
SQL
0 vote194 views1 answer
Mysql function variable
SQL
2 votes199 views1 answer
Mariadb JSON_EXTRACT
SQL