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 vote162 views1 answer
Sql find gaps in date ranges
SQL
0 vote217 views1 answer
Sql int vs integer
SQL
1 vote200 views1 answer
Psql client write to bash variable
SQL
0 vote159 views1 answer
Joins vs includes
SQL
0 vote213 views1 answer
Bash block size ls /var/lib/mysql
SQL
5 votes162 views3 answers
Bash: mysql: command not found
SQL
1 vote171 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote146 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote125 views3 answers
Mysql calculate age from date of birth
SQL
1 vote147 views1 answer
Substr sql last character
SQL