select u.name, o.name, c.name, co.comment$
from sys.obj$ o, sys.col$ c, sys.user$ u, sys.com$ co
where o.owner# = u.user#
  and o.type# in ( 2 ,  4 )
  and o.obj# = c.obj#
  and c.obj# = co.obj#(+)
  and c.intcol# = co.col#(+)
  and bitand(c.property,  32 ) =  0   /* not hidden column */ 

select
  a.table_name, a.column_name
 from
  dba_tab_columns a,
  dba_col_comments b
 where
  a.table_name = b.table_name(+) and
  a.owner = b.owner(+) and
  b.table_name is NULL;

SQLWKS> select
      2 >   a.table_name, a.column_name
      3 >  from
      4 >   dba_tab_columns a,
      5 >   dba_col_comments b
      6 >  where
      7 >   a.table_name = b.table_name(+) and
      8 >   a.owner = b.owner(+) and
      9 >   b.table_name is NULL
     10 > 
TABLE_NAME                     COLUMN_NAME                   
 ------------------------------ ------------------------------
 
C_COBJ#                        OBJ#                          
C_FILE#_BLOCK#                 TS#                           
C_FILE#_BLOCK#                 SEGFILE#                      
C_FILE#_BLOCK#                 SEGBLOCK#                     
C_MLOG#                        MASTER                        
C_MLOG#                        MOWNER                        
C_OBJ#                         OBJ#                          
C_OBJ#_INTCOL#                 OBJ#                          
C_OBJ#_INTCOL#                 INTCOL#                       
C_RG#                          REFGROUP                      
C_TOID_VERSION#                TOID                          
C_TOID_VERSION#                VERSION#                      
C_TS#                          TS#                           
C_USER#                        USER#                         
Выбрано  14  строк.