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 vote268 views1 answer
Update using case in mysql
SQL
0 vote268 views3 answers
Group_concat sql server
SQL
1 vote226 views1 answer
Oracle boolean to varchar
SQL
0 vote301 views1 answer
SQL-Arten
SQL
0 vote318 views2 answers
Mysql cast to varchar
SQL
1 vote274 views1 answer
Error code 1175 mysql fix
SQL
0 vote275 views1 answer
Where name ends in SQL
SQL
1 vote281 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote269 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
10 votes267 views4 answers
Join with multiple conditions sql
SQL