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!

how to import data from CSV file with columns separated by semicolon?

683261Feb 4 2009 — edited Apr 1 2009
I migrate database from MS SQL 2008 to ORACLE 11g

I export data to CSV file from MS SQL

then I try to import it to Oracle

several tables goes fine using Import data option in the SQL Developer

Standard CSV files with data separated by comma were imported.

chars, date (with format string), and integer data are imported via import wizard without problems

the problems were when I try to import table with noninteger numbers with modal part separated by comma not by dot

comma is the standard separator for columns in CSV file

so I must change the standard separator to semicolon

then the import wizard have problem to correct recognize the columns data because it use only standard CSV comma separator :-/

In SQL Developer 1.5.3 Tools -> Preferences -> Migration -> Data Move Options

I change "End of Column Delimiter" to ; but it doens't work

Is this possible to change the standard column separator for import data wizzard in SQL Developer 1.5.3?

Or maybe someone know how to import data in SQL Developer 1.5.3 from CSV when CSV colunn separator is set to semicolon?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2009
Added on Feb 4 2009
2 comments
4,980 views