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 vote198 views1 answer
Capitole toulouse
SQL
1 vote173 views1 answer
Woocommerce mysql price table
SQL
0 vote199 views1 answer
Renommer base sql
SQL
1 vote210 views1 answer
OSError: mysql_config not found
SQL
1 vote231 views1 answer
Postgresql float 2 decimal places
SQL
0 vote166 views1 answer
Postrgres trunc
SQL
0 vote159 views1 answer
Dnsmasq.conf location macos
SQL
0 vote177 views1 answer
PostgreSQL types and C# types
SQL
1 vote198 views1 answer
Get parameter value in mysql trigger
SQL
7 votes180 views1 answer
Postgres base size
SQL