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 vote244 views1 answer
Why we have to set the password for my sql server
SQL
0 vote232 views1 answer
Postgresql select fast check no rows
SQL
3 votes223 views2 answers
Mysql add 2 hours
SQL
2 votes246 views1 answer
Oracle percentage
SQL
27 votes240 views6 answers
Set password mysql
SQL
0 vote240 views1 answer
How to add unique key constraint in mysql
SQL
0 vote238 views1 answer
Sql add calculated column
SQL
-1 vote250 views2 answers
Create temporary table sql
SQL
16 votes236 views6 answers
Mysql find and replace
SQL
4 votes268 views3 answers
Sql find second highest salary employee
SQL