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 vote278 views1 answer
SQL add a totals of differemt rows of the same id
SQL
42 votes376 views6 answers
Rename table sql server
SQL
0 vote264 views1 answer
Mysql create table like
SQL
5 votes285 views1 answer
Oracle nls instance
SQL
0 vote357 views2 answers
Insert data into multiple tables mysql
SQL
0 vote262 views2 answers
Clear window pl sql
SQL
1 vote277 views1 answer
Postgresql escape single quote
SQL
0 vote271 views1 answer
Declarative base sqlalchemy
SQL
2 votes283 views1 answer
Oracle run_duration average
SQL
3 votes276 views3 answers
Concatenation in sql
SQL