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