Create table as select PL/SQL

1

How can a create a table based on select if the output of the query is mostly numeric but can exist also values of type DATE which can exist in any of the columns (values of type DATE are not relevant and can be converted in NULL when are find)?
e.g:

NR camp1 camp2 camp3 camp4 camp5 camp6 capm7 camp8 camp9
19110814253903F00 78312 61026 61269 61285 2/4/2010 13:51

2

try specifying in the title what language are you talking about, and show what you have tried so far, so that people can better find the topic and better help you