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 vote176 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote214 views1 answer
Eliminate zero from integer mysql
SQL
0 vote375 views1 answer
Why do we need data structure in sql
SQL
3 votes191 views1 answer
Oracle limit user tablespace
SQL
1 vote194 views1 answer
Mysql order by desc null last
SQL
1 vote175 views2 answers
Mysql allow remote connections
SQL
0 vote226 views1 answer
Oracle sql date winter time
SQL
0 vote191 views1 answer
Oracle query to find schema you are working on
SQL
7 votes185 views1 answer
Buy forge mods server hosting
SQL
19 votes189 views6 answers
Sql create table
SQL