select count(*) from user_tab_columns where Table_name=upper('yourtable')
SQL> desc A; Name Type Nullable Default Comments ---- ------------ -------- ------- -------- A1 VARCHAR2(10) Y A2 VARCHAR2(10) Y A3 VARCHAR2(10) Y SQL> select count(0) from user_col_comments where table_name = 'A'; COUNT(0) ---------- 3Executed in 0.016 secondsSQL>
where Table_name=upper('yourtable')
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
A1 VARCHAR2(10) Y
A2 VARCHAR2(10) Y
A3 VARCHAR2(10) Y SQL> select count(0) from user_col_comments where table_name = 'A'; COUNT(0)
----------
3Executed in 0.016 secondsSQL>