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 vote197 views1 answer
Drop procedure sql
SQL
0 vote182 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote198 views1 answer
Order by with where clause in mysql
SQL
0 vote213 views1 answer
Power bi find all ids not in other tables
SQL
0 vote195 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote187 views1 answer
Oracle sql listagg
SQL
3 votes209 views1 answer
Oracle list invalid password logon denied
SQL
0 vote199 views1 answer
Querry mysql by 2 columns
SQL
14 votes204 views4 answers
Online sql compiler
SQL
1 vote198 views1 answer
Update from select oracle
SQL