Commentaire table 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

1 vote355 views1 answer
Postgresql last element of array
SQL
1 vote362 views1 answer
Mysql tables max count
SQL
3 votes399 views1 answer
Postgres select max value
SQL
0 vote355 views1 answer
Sql comand for removing data from table
SQL
0 vote365 views1 answer
How to display value of variable in mysql
SQL
2 votes355 views1 answer
Postgresql transaction
SQL
3 votes394 views2 answers
Check data in table mysql
SQL
-1 vote340 views1 answer
Sql syntax create timestamp column
SQL
2 votes358 views3 answers
Postgresql reset auto increment
SQL
1 vote350 views1 answer
Sql query row number group by
SQL