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 vote347 views1 answer
Type int in mysql maxlenght
SQL
1 vote348 views1 answer
Oracle db create new schema
SQL
0 vote358 views1 answer
Sqlplus change user
SQL
0 vote402 views2 answers
Impala rename column name
SQL
4 votes366 views4 answers
Pl sql output
SQL
5 votes372 views1 answer
Invalid column name sql
SQL
4 votes361 views3 answers
Postgres set default value
SQL
0 vote344 views1 answer
Mysql Error Code: 1005
SQL
0 vote338 views1 answer
Oracle sqlp update amount / quantity
SQL
1 vote388 views1 answer
Sql drop schema
SQL