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 vote142 views1 answer
Oracle job schedules
SQL
0 vote121 views1 answer
Sql server whoami
SQL
1 vote146 views1 answer
Sql view where tables have same column name combine results
SQL
14 votes125 views3 answers
Trim sql
SQL
2 votes113 views1 answer
Mysql auto increment jumping
SQL
0 vote125 views1 answer
Mysql create table columns with spaces
SQL
14 votes132 views3 answers
Alter foreign key
SQL
0 vote126 views1 answer
Postgres float to int
SQL
0 vote132 views1 answer
How much table store postgres
SQL
3 votes145 views2 answers
Mysql select database
SQL