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 vote138 views1 answer
Create column that already exists mysql
SQL
0 vote135 views1 answer
Mysql cli output to a file
SQL
1 vote140 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
1 vote127 views1 answer
Alter table column size oracle
SQL
0 vote133 views1 answer
Split string by comma in sql server
SQL
0 vote144 views1 answer
Typical max-connect-errors mysql
SQL
0 vote148 views1 answer
Mql5 datetime get hour
SQL
0 vote148 views1 answer
Soql last week
SQL
0 vote192 views1 answer
Replace null value within column mysql
SQL
0 vote131 views1 answer
Laravel general error 2006 mysql server has gone away
SQL