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'
I just tried this with a mysql db, but I only have the option open, export and copy to oracle in the right click menu. What could be missing, some kind of filter/extension?
ReplyDelete20150717wanglili
ReplyDeletecoach outlet
louis vuitton outlet
louis vuitton
abercrombie
louis vuitton
fitflop footwear
retro jordans
hollister clothing
louis vuitton uk
hollister kids
christian louboutin
hollister
coach outlet
abercrombie & fitch
lululemon
christian louboutin sale
mont blanc
football shoes
louis vuitton handbags
juicy couture
louis vuitton
tory burch
coach outlet
air jordan 11
celine outlet
kate spade handbags
oakley sunglasses wholesale
tods outlet
louis vuitton outlet
burberry outlet online
jordan 13
tory burch outlet, nike air max, uggs on sale, longchamp, nike air max, ray ban sunglasses, tiffany and co, tiffany jewelry, oakley sunglasses, louis vuitton, ugg boots, oakley sunglasses, ugg boots, louboutin outlet, ray ban sunglasses, prada handbags, michael kors, burberry, oakley sunglasses, nike outlet, louis vuitton outlet, louis vuitton, replica watches, michael kors outlet, michael kors outlet, michael kors outlet, nike free, kate spade outlet, chanel handbags, oakley sunglasses, longchamp outlet, longchamp outlet, polo ralph lauren outlet, replica watches, burberry outlet online, prada outlet, ugg boots, louis vuitton, gucci outlet, louboutin, michael kors outlet, louis vuitton outlet, jordan shoes, ugg boots
ReplyDeletelacoste pas cher, nike air max, vans pas cher, replica handbags, mulberry, michael kors, true religion jeans, air jordan pas cher, north face, air max, ralph lauren uk, oakley pas cher, coach outlet, north face, louboutin pas cher, tn pas cher, sac guess, michael kors, coach purses, nike roshe run, hogan, coach outlet, nike free run uk, sac longchamp, hermes, ray ban pas cher, hollister pas cher, kate spade handbags, nike free, vanessa bruno, timberland, nike air max, michael kors, ray ban uk, lululemon, ralph lauren pas cher, burberry, hollister, nike blazer, michael kors, true religion outlet, longchamp pas cher, nike roshe, true religion jeans, new balance pas cher, air force, converse pas cher, nike air max, abercrombie and fitch, true religion jeans
ReplyDeletebottega veneta, ferragamo shoes, timberland boots, oakley, soccer jerseys, wedding dresses, herve leger, nike air max, chi flat iron, instyler, mcm handbags, lululemon, nike huarache, baseball bats, ralph lauren, hollister, asics running shoes, iphone cases, mac cosmetics, hollister, insanity workout, ipad cases, valentino shoes, iphone 6s cases, jimmy choo shoes, north face outlet, nfl jerseys, iphone 6 plus cases, iphone 6s plus cases, ghd, iphone 6 cases, babyliss, nike roshe, abercrombie and fitch, soccer shoes, celine handbags, north face outlet, giuseppe zanotti, nike trainers, louboutin, beats by dre, new balance, mont blanc, s5 cases, vans shoes, birkin bag, iphone 5s cases, longchamp, p90x workout, reebok shoes
ReplyDeletemoncler, juicy couture outlet, thomas sabo, swarovski crystal, barbour jackets, canada goose outlet, karen millen, canada goose, replica watches, pandora jewelry, ugg,ugg australia,ugg italia, vans, marc jacobs, louis vuitton, louis vuitton, supra shoes, moncler, canada goose, barbour, bottes ugg, ugg pas cher, doudoune canada goose, links of london, moncler, ray ban, louis vuitton, coach outlet, converse outlet, moncler, montre pas cher, sac louis vuitton pas cher, hollister, moncler, lancel, canada goose outlet, pandora charms, louis vuitton, canada goose uk, hollister, moncler outlet, canada goose, doke gabbana outlet, ugg,uggs,uggs canada, pandora jewelry, moncler, moncler, gucci, ugg boots uk, juicy couture outlet, pandora charms, converse, swarovski, wedding dresses
ReplyDeleteralph lauren uk
ReplyDeletebabyliss pro
tiffany and co
lululemon outlet online
bottega veneta outlet online
michael kors uk
michael kors factory online
cheap oakley sunglasses
cheap oakley sunglasses
oakley sunglasses wholesale
ray-ban sunglasses
cheap ray ban sunglasses
ray-ban sunglasses
ray ban sunglasses
coach handbags outlet
coach outlet online
coach outlet store
coach outlet
coach outlet store
tory burch outlet online
tory burch outlet online
tory burch outlet
coach outlet store
ray ban sunglasses
christian louboutin shoes
cazal outlet
versace sunglasses on sale
louis vuitton sunglasses for women
dior outlet
gucci sunglasses uk
chrome hearts outlet
chrome hearts outlet online
police sunglasses for men
cartier sunglasses for men
cartier outlet store
lllllyuan20160601
chenlili20160627
ReplyDeletenike roshe one
coach outlet
kobe 9
basketball shoes
oakley sunglasses outlet
coach outlet store online
ray ban sunglasses
louis vuitton purses
christian louboutin
michael kors outlet
tiffany jewelry
louboutin
toms outlet
giuseppe zanotti outlet
louis vuitton
longchamp le pliage
jordan 11
coach outlet
true religion outlet
lebron shoes for kids
coach outlet canada
michael kors outlet online
cheap rolex watches
cheap jordans
adidas originals shoes
michael kors outlet clearance
louis vuitton outlet
nike blazers shoes
pandora outlet
true religion outlet
michael kors outlet
coach outlet store online
ralph lauren outlet
ralph lauren outlet
toms wedges
fitflop shoes
supra shoes
ray ban sunglasses
zhengjx20160816
ReplyDeletetrue religion outlet
oakley sunglasses
montblanc pen
jordan retro 13
concords 11
chicago bulls jerseys
fitflop shoes
louboutin femme
gucci outlet online
celine bags
burberry handbags
ugg outlet
cheap ray ban sunglasses
ugg italia
cheap ray ban sunglasses
lebron 13
michael kors outlet online
louis vuitton canada
cartier watches outlet
boston celtics jerseys
ray ban sunglasses uk
louis vuitton purses
cheap rolex watches
michael kors outlet
canada goose jackets
ugg boots
cheap uggs
toms outlet
uggs outlet
michael kors handbags
rolex watches
celine handbags
ray ban outlet
cheap jordans
coach factory outlet
michael kors outlet
moncler jackets
louis vuitton outlet
christian louboutin outlet
adidas yeezy
ReplyDeleteشركة عزل اسطح وخزانات بالاحساء
شركة عزل اسطح بالرياض
شركة عزل خزانات المياه بالرياض
20160914 junda
ReplyDeletelebron james shoes
michael kors handbags
canada goose
louis vuitton
mac cosmetics
oakley sunglasses
air jordan 13
prada sunglasses
cartier watches
uggs outlet
coach outlet clearance
jordan shoes
longchamp pliage
ferragamo shoes
michael kors handbags
louis vuitton handbags
ugg australia
rolex watches
rolex outlet
michael kors handbags
celine outlet
michael kors outlet online
louis vuitton outlet stores
futbol baratas
fitflop clearance
oakley sunglasses
tods outlet
mbt shoes
adidas wings
calvin klein underwear
tiffany outlet
ugg boots
cheap michael kors handbags
canada goose outlet
nike outlet
air jordan 4
moncler coats
coach outlet clearance
michael kors outlet online
replica watches
fake rolex watches
ReplyDeletecoach outlet online
toms outlet store
michael kors handbags outlet
red bottom
canada goose coats
moncler coats
Replica Rolex
north face jackets
toms outlet
zhi20161126
new york knicks jersey
ReplyDeletesalomon shoes
michael kors handbags online
michael kors outlet
titans jersey
canada goose jackets
nike blazer low
cheap oakley sunglasses
polo ralph lauren outlet
mlb jerseys
coach outlet
ReplyDeleteabercrombie kids
cheap ugg boots
michael kors canada
true religion jeans
fitflops
rolex replica watches
louis vuitton outlet
louis vuitton
ralph lauren outlet
20170223caiyan
nike roshe run
ReplyDeletelongchamp
harden shoes
クロムハーツ
adidas nmd
yeezy boost 350 v2
nike huaraches
af1
yeezy boost 350 v2
hogan outlet online
mt1101
ReplyDeletepolo outlet
moncler coats
coach factory outlet
coach outlet
pandora charms
coach outlet
air jordans
polo ralph lauren outlet online
kate spade handbag
james harden shoes
mt1101
If you have a mobile app development company and you need a dedicated android or iPhone app developer, then dedicated developers can help. Since these areas need expertise in the field, it is important to hire experts to get your task completed.Edknt Media
ReplyDeleteI'll review this blog as An and it demonstrates how much exertion has been put into this.
ReplyDeletecomo importar dos eua
oakey sunglasses outlet
ReplyDeleteralph lauren uk
kate spade outlet
ralph lauren outlet
canada goose jackets
red bottom heels
michael kors outlet store
nike huarache shoes
pandora jewelry
supra for sale
clb20180523
This article is interesting and useful. Thank you for sharing. And let me share an article about health that God willing will be very useful. Thank you :)
ReplyDeletePengobatan efektif Menghilangkan Benjolan di Payudara
Obat Luka Berair yang Tak Kunjung Sembuh
Pengobatan Miom tanpa Operasi
Cara Mengobati Sakit Dada secara Alami
Cara Mengobati sakit Telinga Secara Alami
Obat Herbal Penghancur Miom
The term Agile software development was coined in the year 2001, subsequently to the formulation of the Agile Manifesto. DB Designer
ReplyDeleteFlutter Programming is one of the most popular in the cross platforms industry. We build excellent flutter mobile app and also learn how to overcome performance issues. Offshore Flutter Development Service is the best choice for all startups to discuss and get their project quotation. We also enable many startups to do Proof of concept and help them to learn about business decisions.
ReplyDeleteAre you a web developer? Then give a helping hand to your young ones. Let's grow the world knowledge. Head over to Thinkle Developers and help a seeker please.
ReplyDeletehttps://www.alraid-sa.com
ReplyDeletehttps://www.alraid-sa.com/شركة-تركيب-جبس-بورد-بالرياض/
https://www.alraid-sa.com/شركة-شحن-من-الرياض-لمصر/
https://www.alraid-sa.com/معلم-دهانات-بالرياض/
https://www.alraid-sa.com/شركة-تركيب-طارد-حمام-بالمدينة-المنورة/
https://www.alraid-sa.com/شركة-نقل-عفش-من-جدة-الى-الرياض/
https://www.alraid-sa.com/شركة-نقل-عفش-من-جدة-الى-الامارات/
Python Development Services providers across the world for developing a wide range of software applications. It allows developers to express concept with less and readable code. It enable the developers to integrate Python with varied other well-known programming languages and tools flawlessly. unindent does not match any outer indentation level python
ReplyDelete