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

2 votes134 views2 answers
Calculate percentage in sql
SQL
0 vote122 views1 answer
Change magento database url usimg musql
SQL
-1 vote107 views3 answers
Mysql get age from date
SQL
2 votes64 views1 answer
Sql select in list
SQL
0 vote118 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote112 views1 answer
First mysql
SQL
1 vote151 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote120 views1 answer
How to start my sql server on mac
SQL
0 vote180 views1 answer
Mysql update table from select on another table
SQL
0 vote117 views1 answer
Null column as zero in mysql
SQL