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 vote209 views1 answer
If column value is null then in mysql
SQL
0 vote258 views1 answer
Insert query return id mysql
SQL
8 votes200 views3 answers
Connect python to mysql
SQL
0 vote188 views1 answer
Selecting Data in SQL - Select Data
SQL
1 vote203 views1 answer
Mysql login console
SQL
0 vote250 views1 answer
Install squirrel sql ubuntu
SQL
1 vote223 views2 answers
Mysql does sentance contain word
SQL
1 vote398 views2 answers
Coderbyte sql solutions
SQL
0 vote242 views1 answer
Select top 3 sql
SQL
0 vote208 views1 answer
How to remove default in mysql
SQL