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 vote197 views1 answer
Md5 encryption for existing records
SQL
-1 vote149 views3 answers
Ubuntu install mssql
SQL
2 votes195 views2 answers
Checking data type in sql server
SQL
1 vote188 views1 answer
Postgres count string length
SQL
2 votes207 views2 answers
Create empty table from existing table
SQL
5 votes200 views3 answers
Postgres show databases
SQL
2 votes195 views1 answer
Sql update alias
SQL
1 vote200 views1 answer
Mysql show long running queries
SQL
0 vote198 views1 answer
Date 3 months from today sql
SQL
0 vote182 views1 answer
Oracle string substitution
SQL