The DBA_TAB_COMMENTS view provides the information on all comments in all tables and views.

Parameter Type Description
Parameter Type Description
owner CHARACTER VARYING The username of the owner of a table or view.
schema CHARACTER VARYING The name of the schema to which the table or the view belongs.
table_name CHARACTER VARYING The name of the table or view.
table_type CHARACTER VARYING The type of the table, which can be table, view, and materialized view.
comments CHARACTER VARYING The comments on the table.