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

1 vote198 views2 answers
ImportError: No module named mysql.connector
SQL
4 votes169 views2 answers
Select todays data postgres query
SQL
0 vote219 views1 answer
Como hacer una consulta en sql
SQL
7 votes213 views2 answers
3rd height salary sql
SQL
5 votes215 views1 answer
Sql table columns
SQL
1 vote184 views1 answer
Avg mysql
SQL
1 vote230 views1 answer
Events mysql
SQL
0 vote198 views1 answer
Add colum date in sql
SQL
0 vote255 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote201 views1 answer
Oracle create table auto generated primary key
SQL