Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display Column Comment in AS "good comment"

Neel shahNov 30 2022 — edited Nov 30 2022

Hello ,
I have need to display Column Comment and value .
For example

create table tst_delete (col1 int); 
comment on column tst_delete.col1 is 'is my column comment';

Desc table
COL1 NUMBER(38,0) Yes 1 is my column comment

Select * from tst_delete;
expected output.
is my column comment 
5 

Since my huge table has comment nicely defined I want to map those to values.
Any suggestions
TIA <3

Comments
Post Details
Added on Nov 30 2022
6 comments
6,368 views