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 vote344 views1 answer
Sql server alter table add column tinyint
SQL
1 vote323 views1 answer
Order by oracle
SQL
2 votes318 views1 answer
Sql server find table name
SQL
0 vote325 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote333 views1 answer
Sql string contains case sensitive
SQL
0 vote320 views1 answer
Is not sql
SQL
1 vote358 views3 answers
Union SQL
SQL
7 votes325 views1 answer
Connect mysql docker
SQL
0 vote347 views1 answer
How to retrive the today date sql
SQL
0 vote317 views1 answer
Minus equivalent in my sql
SQL