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 vote153 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote138 views1 answer
Show specific events on mysql
SQL
3 votes150 views2 answers
Monthname sql
SQL
8 votes144 views1 answer
Ltrim sql
SQL
0 vote184 views1 answer
Mysl like insert a variable
SQL
2 votes168 views1 answer
Sql skip the first row
SQL
0 vote134 views1 answer
How to find unique key in sql
SQL
1 vote148 views3 answers
Mysql parse int
SQL
0 vote144 views1 answer
C# mysql update statement set value to null
SQL
11 votes155 views1 answer
Sql insert multiple rows from select
SQL