Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Weird Behavior of Sqldevoper Import Data

user-r26dyMay 2 2023

Hello All,

I am trying to import data from excel to Oracle developer.

My problem here is with number datatype.

In excel file, numbers are shown properly but as soon as I import it in Oracle, it is shown differently.

eg. in Excel if it is 25, in imported version of Oracle, it is showing 2499999999.

And this is happening with multiple columns having number datatype.

Any feedback is highly appreciated.

Comments
Post Details
Added on May 2 2023
1 comment
324 views