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

8 votes174 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote112 views1 answer
Postgresql add not null and not empty constraint
SQL
13 votes116 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote118 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote117 views1 answer
Mysql query problems and solutions
SQL
21 votes116 views3 answers
Sql average
SQL
0 vote120 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
5 votes119 views5 answers
Find max number in sql
SQL
7 votes100 views3 answers
Add primary key to database sql
SQL
5 votes122 views1 answer
Get column name sql server
SQL