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
and
execute with oracle or root:
[oracle@lv-test ~]$ sqldeveloperOracle 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
create table TEST1 (column1 VARCHAR(100),column2 VARCHAR(100));
- right click on the table select 'import data'