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?
ReplyDeletetory 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
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
ReplyDelete
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
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
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
The term Agile software development was coined in the year 2001, subsequently to the formulation of the Agile Manifesto. DB Designer
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
ReplyDeleteyoutube abone satın al
ReplyDeletetrendyol indirim kodu
cami avizesi
cami avizeleri
avize cami
no deposit bonus forex 2021
takipçi satın al
takipçi satın al
takipçi satın al
takipcialdim.com/tiktok-takipci-satin-al/
instagram beğeni satın al
instagram beğeni satın al
btcturk
tiktok izlenme satın al
sms onay
youtube izlenme satın al
no deposit bonus forex 2021
tiktok jeton hilesi
tiktok beğeni satın al
binance
takipçi satın al
uc satın al
sms onay
sms onay
tiktok takipçi satın al
tiktok beğeni satın al
twitter takipçi satın al
trend topic satın al
youtube abone satın al
instagram beğeni satın al
tiktok beğeni satın al
twitter takipçi satın al
trend topic satın al
youtube abone satın al
takipcialdim.com/instagram-begeni-satin-al/
perde modelleri
instagram takipçi satın al
instagram takipçi satın al
takipçi satın al
instagram takipçi satın al
betboo
marsbahis
sultanbet
Mmorpg Oyunlar
ReplyDeleteİnstagram Takipci Satın Al
tiktok jeton hilesi
tiktok jeton hilesi
antalya saç ekimi
referans kimliği nedir
instagram takipçi satın al
MT2 PVP SERVERLER
takipçi satın al
Good content. You write beautiful things.
ReplyDeletehacklink
vbet
mrbahis
vbet
sportsbet
sportsbet
mrbahis
korsan taksi
hacklink
Thanks for sharing
ReplyDeleteKeystone Bank Code | How To Check Account Balance On Keystone Bank
Good text Write good content success. Thank you
ReplyDeletemobil ödeme bahis
betmatik
tipobet
poker siteleri
slot siteleri
kibris bahis siteleri
betpark
kralbet
Nice content.
ReplyDeletezamcash customer care number
sultangazi
ReplyDeleteordu
mardin
bodrum
sincan
2NY
maraş
ReplyDeletebursa
tokat
uşak
samsun
EYL
salt likit
ReplyDeletesalt likit
dr mood likit
big boss likit
dl likit
dark likit
S1E