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

7 votes298 views2 answers
Sql empty table
SQL
1 vote203 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote206 views1 answer
We are intrested to work with your organization
SQL
5 votes289 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote206 views1 answer
Select place default lat long
SQL
0 vote215 views1 answer
Oracle sql add column auto generated value
SQL
17 votes271 views6 answers
Get last record in sql
SQL
9 votes232 views6 answers
Sql add column with default value
SQL
1 vote162 views1 answer
Pagination sql
SQL
0 vote203 views1 answer
Mysql record group by created date count
SQL