Skip to Main Content

SQL Developer

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!

Import Data from Excel - uppercase characters converted to lowercase

16967Jan 5 2007 — edited Jan 31 2007
Hi,

I have noticed a problem when importing data into a table from excel - all uppercase characters are converted to lowercase.
SQLDeveloper version 1.1.0.23.64
MS Excel 2002 (10.6789.6802) SP3
Oracle 9.2.0.6.0

Interestingly, the insert sql displayed shows the original uppercase values.
Additionally, not all the insert statements are shown - I don't know if this is intentional or not.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2007
Added on Jan 5 2007
2 comments
1,063 views