Casting String to Integer
Date: December 11, 2005 09:57AM
in the database there is a field ktnr as String, but ktnr should only be Integer!
if i create a new table with ktnr INTEGER and load the data, there will be a mistake, if ktnr includes not only integer values :-( For example: "123456e"
How can i solve the problem?
1. How can i convert String to Integer and conclude the exception cases into the query!?
2. How can i start the database (or write the query) such waz, that in exception case there won´t be a brealk!?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.