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

1 vote248 views1 answer
Oracle select row max date
SQL
1 vote217 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
6 votes238 views2 answers
Mysql get yesterday
SQL
0 vote209 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote230 views1 answer
Query to insert image
SQL
10 votes240 views1 answer
Query to find object dependencies in oracle
SQL
0 vote244 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote246 views1 answer
How to get data from 2 database
SQL
0 vote233 views1 answer
Replace sqlalchemy
SQL
5 votes235 views3 answers
Select tables from mysql database
SQL