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 vote291 views1 answer
Change date format in oracle query
SQL
3 votes262 views1 answer
Oracle revoke grant
SQL
0 vote276 views1 answer
Oracle select partition
SQL
10 votes267 views2 answers
Show tables in schema oracle
SQL
57 votes447 views6 answers
Mysql alter table add column
SQL
8 votes255 views2 answers
Mysql query dates between two dates
SQL
0 vote268 views1 answer
Postgres execute multiple sql file from command line
SQL
3 votes264 views3 answers
Create table in microsoft sql server
SQL
0 vote273 views3 answers
Mysql regex replace
SQL
0 vote248 views1 answer
Sql view index
SQL