Oracle create table comment

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 vote320 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote371 views1 answer
Declare or use variable in snowflake
SQL
1 vote361 views1 answer
Update from table tsql
SQL
0 vote402 views1 answer
Query only first letter string
SQL
14 votes342 views3 answers
Oracle sql limit results
SQL
2 votes351 views1 answer
Oracle run_duration average
SQL
8 votes363 views3 answers
Postgres connection string
SQL
-1 vote331 views3 answers
Update mongodb version ubuntu
SQL
5 votes341 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote343 views1 answer
How to create a new db from dumb file mysql
SQL