I have following flat file
SR_ID UPDATED_TIME
1-XYZ 20-SEP-07 10.10.10.000000 AM
1-XYZ 20-SEP-07 10.20.10.000000 AM
1-XYZ 20-SEP-07 10.40.10.000000 AM
1-XYZ 20-SEP-07 11.10.10.000000 AM
1-XYZ 20-SEP-07 11.20.30.000000 AM
1-XYZ 20-SEP-07 12.12.10.000000 PM
1-XYY 20-SEP-07 12.40.10.000000 PM
I want to import this flat file in oracle table. But i don't know what datatype i should take for Updated_time in oracle table
PLease help me out