SHOW COMMENTs
SHOW COMMENTs
This command displays all comments that have been created, on various objects, in the current database.There is no option to display a specific comment.Each comment is listed along with the object type and name, to which it has been applied.
SQL> show comments; COMMENT ON DATABASE IS This is the demonstration EMPLOYEE database.; COMMENT ON TABLE EMPLOYEE IS The EMPLOYEE table has details of our employees.;
The actual comment text is shown between the word 'IS' and the trailing semicolon.