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 vote324 views2 answers
How to see table associated with a schema in sql
SQL
3 votes342 views2 answers
Sql get month name
SQL
0 vote321 views1 answer
Sql count null as 0
SQL
1 vote273 views1 answer
How to run sql script
SQL
0 vote369 views1 answer
Sqlite version check
SQL
1 vote337 views1 answer
SQL: merging multiple row data in string
SQL
1 vote322 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote344 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote344 views1 answer
Select all columns except one sql
SQL
19 votes322 views6 answers
Laravel sql query
SQL