Oracle create table comment

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 vote199 views1 answer
Soql last week
SQL
1 vote206 views1 answer
Sqlite3 read only
SQL
12 votes207 views6 answers
Between in sql
SQL
0 vote192 views1 answer
Mysql get 2nd value in comma separated list
SQL
11 votes193 views2 answers
Having keyword sql
SQL
0 vote233 views1 answer
SQL-Arten
SQL
2 votes216 views2 answers
Install postgresql
SQL
0 vote219 views1 answer
Mysql Selected All Duplicate Rows
SQL
5 votes209 views2 answers
Get columns number sql
SQL
0 vote231 views2 answers
How to drop mili second in sql
SQL