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 vote315 views1 answer
List all permissions on a table in postgres
SQL
3 votes301 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote311 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
33 votes311 views6 answers
Change column name in mysql
SQL
10 votes313 views6 answers
Sql between
SQL
0 vote307 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
7 votes335 views2 answers
Mysql check db size
SQL
1 vote298 views2 answers
Replace text in sql
SQL
1 vote276 views2 answers
Into sql
SQL
0 vote305 views1 answer
How to export only procedures mysql
SQL