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

0 vote163 views2 answers
Mysql dump structure only
SQL
0 vote165 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote144 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote168 views3 answers
Join
SQL
0 vote160 views1 answer
Joomla execute raw sql
SQL
0 vote153 views2 answers
Change database postgres
SQL
0 vote148 views1 answer
Mysql drop trigger
SQL
0 vote147 views1 answer
Stored function in sql
SQL
0 vote139 views1 answer
Select other columns with distinct
SQL
0 vote139 views1 answer
FIND most frequent word in sql server
SQL