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µÄ¹Ü·½Îĵµ°É¡£ÒýÓà ÄǸö³É¼ªË¼£¬º¹°¡¡¡ ¿´¿´ORACLE¹ØÓÚsql loaderµÄ¹Ü·½Îĵµ°É¡£ ºÃ ¸ßÊÖ֮ǰû¼û¹ýÕâÖÖÇé¿öÂ𣿠{{---
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dnam ......