CODE EXAMPLE FOR SQL

oracle see column type

SELECT  table_name, column_name, data_type, data_length FROM all_tab_columns where table_name = 'CUSTOMER'