Is there a SQL command you can run against an Oracle database to find out what datatype a certain field is?
SELECT column_name, data_type FROM all_tab_columns WHERE table_name = 'DUAL';
Make sure your table name is all uppercase.
