Why numeric data truncated to be integer when declaring NUMBER data type in Oracle 10g
Hello, My company recently upgraded Oracle server form 9i to 10g and I was requested to load all tables data from 9i to 10g. Most data transfer are good except this situation:If 9i table with date type declared as NUMBER, all numeric data will be truncated as integer in 10g (I used the same...
View Answer
| Nov 30 2007 9:55 PM GMT
| asked by
Sleu
Oracle 10, Oracle NUMBER data type


