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 vote159 views1 answer
Sql basic commands
SQL
0 vote153 views2 answers
Mysql dump structure only
SQL
0 vote209 views1 answer
Postgresql powershell query
SQL
0 vote128 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote157 views1 answer
Hierarchal database table
SQL
0 vote156 views1 answer
Arithmetic expression in sql
SQL
0 vote224 views1 answer
Mysql delete entire row on condition
SQL
0 vote128 views1 answer
Mysql concat and use as where column
SQL
1 vote166 views1 answer
Oracle repeat_interval 5 minutes
SQL
4 votes139 views2 answers
Oracle set date format
SQL