dear all
gimana caranya mau mengload data excell ke table oracle
tapi loadnya gak semua kolom atau sebagian aja...
saya punya data dibawah ini
---**---
datapmb2002
---**---
no pil1 pil2 pil3 sex jns_smu jumnem jummtnem nil11 nil12 nil13
nil14 nil15 diterima
1 AKT MAN PSI P SMU/MAN IPS 0 0 3 3 4 4 3
2 PSI TI SING P SMU/MAN IPA 0 0 3 9 9 6 9 PSI
3 TE TI MAT L SMU/MAN IPA 0 0 7 10 4 6 6 TE
4 MAN AKT PSI P SMU/MAN IPS 0 0 4 5 4 3 2
5 IKOM AKT P SMU/MAN IPA 0 0 2 7 7 8 5
6 PSI TI IKOM P SMU/MAN IPA 0 0 6 9 7 4 4
7 PSI AKT MAN P SMU/MAN IPA 0 0 4 10 7 3 6
8 FAR TI AKT P SMU/MAN IPA 0 0 7 9 7 7 5
9 AKT TI IKOM P SMU/MAN IPS 0 0 4 8 5 5 3
10 AKT PSI MAN P SMU/MAN IPS 0 0 4 10 6 6 6 AKT
yang saya tahu formatnya begini:
---**---
isi file loader2.ctl
---**---
LOAD DATA
INFILE *
APPEND
INTO TABLE hr.hasil
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(
no_ INTEGER EXTERNAL,
pil1 CHAR,
pil2 CHAR,
pil3 CHAR,
sex CHAR,
jns_smu CHAR,
jumnem CHAR,
jummtnem CHAR,
nil11 DECIMAL EXTERNAL,
nil12 DECIMAL EXTERNAL,
nil13 DECIMAL EXTERNAL,
nil14 DECIMAL EXTERNAL,
nil15 DECIMAL EXTERNAL,
diterima CHAR,
daftarulang CHAR
)
---**---
---------------
data yang saya butuhkan cuma no, nil11,nil12,dst aja
gimana caranya supaya tidak semua kolom terlaod ke tabel
format sqldr giamana sih...?thanks
salam,
hery
---------------------------------
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
