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 vote125 views1 answer
Hangfire clean script
SQL
17 votes207 views6 answers
Get last record in sql
SQL
24 votes178 views6 answers
Replace mysql
SQL
21 votes152 views1 answer
SQL cheat sheet pdf
SQL
1 vote156 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote164 views1 answer
Postgresql using reserved word as column name
SQL
1 vote161 views1 answer
Display total number of tables in mysql
SQL
0 vote182 views1 answer
Postgresql conectar
SQL
1 vote322 views1 answer
Postgres convert text to number
SQL
2 votes169 views2 answers
How to add not null constraint in sql
SQL