Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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»³É¹¦µÄ³¢ÊÔ ÂÒдµÄ

ÒýÓÃ
ÄãÏÈÓÃÎı¾´ò¿ªÕâ¸öÎļþ,Îı¾Ìæ»»¹¦ÄÜ"~"Ìæ»»³É,
È»ºóµ¼Èë


Ì«¸ÐлÀ²  ÎÒ¾ÐÄàÓÚÄǸö¸ñʽµÄÎÊÌâ  ÄúµÄ»Ø´ðÕæÊÇÈÃÎÒëɪ¶Ù¿ª°¡


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ