SQL Developer import from Excel or CSV

Goal: how to import EXCEL,CSV data to Oracle or Mysql DB.

• install SQL DEVELOPER on Windows or Linux. In this example SQL DEV 3.1.07 (optional).
• installation on windows download sqldeveloper-3.1.07.42.zip unzip use it
• installation on linux RHEL 5, download JDK and SQL DEVELOPER

with root:

chmod +x jdk-6u33-linux-x64-rpm.bin

./jdk-6u33-linux-x64-rpm.bin

and

rpm -ivh sqldeveloper-3.1.07.42-1.noarch.rpm

execute with oracle or root:

[oracle@lv-test ~]$ sqldeveloper
Oracle SQL Developer
 Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

• Check what NLS is on DB(optional).
• Check NLS settings in SQL DEV tools->preferences-NLS (optional).

• Create a connection to the database in SQL Developer with proper NLS settings
• Create a table as a destination for the xls data

Example:

create table TEST1 (column1 VARCHAR(100),column2 VARCHAR(100));  

• right click on the table select 'import data' 

• use xls or csv data format
• select file
• use the wizzard 

 done