Home:ALL Converter>Oracle: Query for comments on an invisible column

Oracle: Query for comments on an invisible column

Ask Time:2021-11-02T18:35:38         Author:Julia Hayward

Json Formatter

I have a table with an invisible column, that has a comment attached. The fact it's invisible means the all_col_comments view appears not to acknowledge its existence - although I can quite happily query comments on other column comments in the same table. Either referring to the column explicitly or (ideally) not, is there any query that will retrieve the comment?

(This is Oracle 12c1)

Author:Julia Hayward,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/69808947/oracle-query-for-comments-on-an-invisible-column
yy