SQL & PL/SQL

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!

Importing data from excel(Spread sheet) to Oracle 11g using SQL Developer single apostrophe to two a

user13034857Jul 16 2015 — edited Sep 8 2015

Hello,

when I import data from excel(Spread sheet) to Oracle 11g using SQL Developer single apostrophe is imported as two apostrophes

Below is the example.

Excel data --> apple's

when we import this data to Oracle 11 g using SQL Developer (version 1.5.5) then it is imported with two apostrophes

after imported Oracle data --> apple's

Please let me know how I can resolve this issue.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2015

Added on Jul 16 2015

5 comments

396 views