Select Code to Download

select column_name, data_type from ALL_TAB_COLUMNS where table_name = 
+'FOO';

SQL> desc all_tab_columns;
 Name                                      Null?    Type
...
 V80_FMT_IMAGE                                      VARCHAR2(3)
 DATA_UPGRADED                                      VARCHAR2(3)
 HISTOGRAM                                          VARCHAR2(15)