Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»³É¹¦µÄ³¢ÊÔ ÂÒдµÄ

£¨Ê×ÏȸÐл¸Õ²ÅÓÐλÈÊÐÖ¸æËßÎÒÓÃÎı¾ÎļþÌæ»»  µ«ÊÇÊý¾ÝÁ¿Ìرð´ó  Îı¾Îļþ´ò²»¿ª  ЧÂÊÌØ±ðµÍ Õâ¸ö·½·¨²»¿ÉÐУ©
  ÈçºÎÐ޸ĿØÖÆÎļþ£¬ÒªÇó²»ÐÞ¸ÄÔ­Îı¾  µ¼Èëoracle
ÄǸö³É¼ªË¼£¬º¹°¡¡­¡­


¿´¿´ORACLE¹ØÓÚsql loaderµÄ¹Ü·½Îĵµ°É¡£

ÒýÓÃ
ÄǸö³É¼ªË¼£¬º¹°¡¡­¡­


¿´¿´ORACLE¹ØÓÚsql loaderµÄ¹Ü·½Îĵµ°É¡£

ºÃ  ¸ßÊÖ֮ǰû¼û¹ýÕâÖÖÇé¿öÂð£¿
{{---


Ïà¹ØÎÊ´ð£º

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

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

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracle Ö´ÐÐ˳Ðò - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ