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 vote221 views1 answer
Sort by last two number sql
SQL
0 vote222 views1 answer
Sql server information_schema temp tables
SQL
28 votes194 views6 answers
Mysql change user password
SQL
4 votes192 views1 answer
Phone number sql
SQL
0 vote158 views1 answer
Mysql select top 2
SQL
6 votes193 views2 answers
Mysql convert timestamp to date
SQL
11 votes197 views3 answers
Python sqlite3 create table if not exists
SQL
5 votes189 views2 answers
Sql server port number
SQL
1 vote238 views1 answer
Count of tables in database mysql
SQL
13 votes274 views3 answers
Sql select from multiple tables without join
SQL