txt µ¼Èë oracleµÄÐÂÎÊÌâ
550016~"34jh4"~"0324100123000276"~"01"~"123456ÍÅ
ÒÔÉÏÊÇÎı¾µ¼ÈëÊý¾Ý ²»Òª·ûºÅ
¿ØÖÆÎļþ
load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
infile 'ddd.txt'¡¡¡¡¡¡¡¡¡¡¡¡
append into table DDST_download_comdeta¡¡
( q, terminated by "~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ~"Ϊ½áβ°¡ £©
w, terminated by ""~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ"~"Ϊ½áβ°¡ £©
e, terminated by ""~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ"~"Ϊ½áβ°¡ £©
c, terminated by ""~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ"~"Ϊ½áβ°¡ £©
v, terminated by £¨Õâ¸öÔõôд£©
f char "123") /*×îºófµÄÖµÏëÒª¸³ÉÏͳһµÄÌØÊâÖµÔõôд*/
ÒÔÉ϶¼ÊDz»³É¹¦µÄ³¢ÊÔ ÂÒдµÄ
£¨Ê×ÏȸÐл¸Õ²ÅÓÐλÈÊÐÖ¸æËßÎÒÓÃÎı¾ÎļþÌæ»» µ«ÊÇÊý¾ÝÁ¿Ìرð´ó Îı¾Îļþ´ò²»¿ª ЧÂÊÌØ±ðµÍ Õâ¸ö·½·¨²»¿ÉÐУ©
ÈçºÎÐ޸ĿØÖÆÎļþ£¬ÒªÇó²»ÐÞ¸ÄÔÎı¾ µ¼Èëoracle
ÄǸö³É¼ªË¼£¬º¹°¡¡¡
¿´¿´ORACLE¹ØÓÚsql loaderµÄ¹Ü·½Îĵµ°É¡£
ºÃ ¸ßÊÖ֮ǰû¼û¹ýÕâÖÖÇé¿öÂð£¿
{{---
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......