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 vote214 views1 answer
Update using case in mysql
SQL
0 vote229 views3 answers
Sql parenthetical expression examples
SQL
0 vote220 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote229 views1 answer
000webhost database values insert
SQL
0 vote213 views1 answer
Postgres jsonb array push new element
SQL
0 vote231 views1 answer
Datagrip execute procedure
SQL
-1 vote263 views4 answers
Full outer join in sql
SQL
0 vote210 views1 answer
If null don't update
SQL
7 votes242 views4 answers
Index in mysql
SQL
5 votes220 views2 answers
Oracle rename table
SQL