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 vote127 views1 answer
Acutal month year
SQL
0 vote118 views2 answers
Create sequence if not exists postgres
SQL
8 votes126 views1 answer
Unique vs primary key
SQL
5 votes125 views6 answers
Sql foreign key
SQL
0 vote116 views1 answer
How to use group_concat in sql server
SQL
0 vote110 views1 answer
Mysql select where text contains
SQL
0 vote76 views1 answer
Sql script get all stored procedures from database
SQL
-1 vote127 views1 answer
Default username and password for oracle 11g
SQL
1 vote137 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote148 views1 answer
Stop and start mysql
SQL