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

ÈçºÎ½«TXT,EXCEL»òCSVÊý¾Ýµ¼ÈëORACLEµ½¶ÔÓ¦±íÖÐ

 ·½·¨Ò»£¬Ê¹ÓÃSQL*Loader  
  Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ­´æÔÚ¡£  
  ´óÌå²½ÖèÈçÏ£º  
  1   ½«excleÎļþÁí´æÎªÒ»¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡ÔñÀàÐÍΪcsv£¨¶ººÅ·Ö¸ô£©Ò²ÐУ¬µ«ÊÇÔÚдºóÃæµÄcontrol.ctlʱҪ½«×Ö¶ÎÖÕÖ¹·û¸ÄΪ','(fields   terminated   by   ','£©£¬¼ÙÉè±£´æµ½EÅ̸ùĿ¼¡£  
  2   Èç¹ûûÓдæÔڵıí½á¹¹£¬Ôò´´½¨,¼ÙÉè±íΪtest£¬ÓÐÁ½ÁÐΪdm£¬ms¡£  
  3   ÓüÇʱ¾´´½¨SQL*Loader¿ØÖÆÎļþ£¬ÍøÉÏ˵µÄÎļþÃûºó׺Ϊctl£¬ÆäʵÎÒ×Ô¼º·¢ÏÖ¾ÍÓÃtxtºó׺ҲÐС£±ÈÈçÃüÃûΪcontrol.ctl£¬ÄÚÈÝÈçÏ£º(--ºóÃæµÄΪעÊÍ£¬Êµ¼Ê²»ÐèÒª£©  
   
  ¡¡¡¡load   data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡  --¿ØÖÆÎļþ±êʶ  
  ¡¡¡¡infile   'e:\text.csv'¡¡¡¡¡¡¡¡        --ÒªÊäÈëµÄÊý¾ÝÎļþÃûΪtest.txt  
  ¡¡¡¡append   into   table   test¡¡¡¡ --Ïò±ítestÖÐ×·¼Ó¼Ç¼  
  ¡¡¡¡fields   terminated   by   X'09'¡¡--×Ö¶ÎÖÕÖ¹ÓÚX'09'£¬ÊÇÒ»¸öÖÆ±í·û£¨TAB£© 
       Èç¹û×Ö¶ÎÊý¾ÝÓÐ"",¿É¼ÓÉÏoptionally enclosed  by   '"' 
        trailing   nullcols    
  ¡¡¡¡(dm,ms)¡¡¡¡                                  --¶¨ÒåÁжÔӦ˳Ðò   
±¸×¢£ºÊý¾Ýµ¼ÈëµÄ·½Ê½ÉÏÀýÖÐÓõÄappend£¬ÓÐһϼ¸ÖÖ£ºinsert£¬ÎªÈ±Ê¡·½Ê½£¬ÔÚÊý¾Ý×°ÔØ¿ªÊ¼Ê±ÒªÇó±íΪ¿Õ£»append£¬ÔÚ±íÖÐ×·¼ÓмǼ£»replace£¬É¾³ý¾É¼Ç¼£¬Ìæ»»³ÉÐÂ×°ÔØµÄ¼Ç¼   £»truncate£¬Í¬replace¡£  
  4   ÔÚÃüÁîÐÐÌáʾ·ûÏÂʹÓÃSQL*LoaderÃüÁîʵÏÖÊý¾ÝµÄÊäÈë       
  sqlldr   userid=system/manager@orcl   control='e:\control.ctl'   log=e:\l


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE ¶¯Ì¬Óï¾ä

 ÔÚÒ»°ãµÄPL/SQL³ÌÐò¿ª·¢ÖУ¬¿ÉÒÔʹÓÃSQLµÄDMLÓï¾äºÍÊÂÎñ¿ØÖÆÓï¾ä£¬µ«ÊÇDDLÓï¾ä¼°»á»°Óï¾äÈ´²»ÄÜÔÚPL/SQLÖÐÖ±½ÓʹÓã¬ÒªÏëʵÏÖÔÚPL/SQLÖÐʹÓÃDDLÓï¾ä¼°»á»°¿ØÖÆÓï¾ä£¬¿ÉÒÔͨ¹ý¶¯Ì¬SQLÀ´ÊµÏÖ¡£
       Ëùν¶¯Ì¬SQLÊÇÖ¸ÔÚPL/SQL¿é±àÒëʱSQLÓï¾äÊDz»È·¶¨µÄ£¬ÀýÈç¸ù¾ÝÓû§ÊäÈë²ÎÊýµÄ²»Í¬¶ø ......

[Oracle] ÖØÐ·ÖÎö±íʹÊý¾Ý¿â×Ô¶¯Ñ¹Ëõ±í¡£

oracle11g¾ßÓÐ×Ô¶¯µÄ±íѹËõ¹¦ÄÜ£¬ µ«µ±insertÓï¾äδָ¶¨¾ßÌåµÄÁÐÃûʱ£¬ »áʹÓÃ×Ô¶¯±íѹËõ¹¦ÄÜʧЧ¡£(Èç¸ÃÓï¾ä»áʹµÃ±ít_test²»ÄÜ×Ô¶¯Ñ¹Ëõ: insert into t_test select * from t_test2)
ÁíÍâʹÓÃһЩÍⲿ¹¤¾ß½øÐÐÊý¾Ý×°ÔØ(sqlload)£¬Ò²ÓпÉÄÜʹµÃ±í²»ÄÜ×Ô¶¯Ñ¹Ëõ£¬´ËʱÐèÒªÓÃÒÔÏÂÓï¾ä£¬ÒÔÖØÐ·ÖÎö±í£¬·ÖÎöÍê³ÉÖ®ºó£¬¸Ã±í¼´»á ......

Introduction to Oracle Wait Interface notes

     ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾­ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊ ......

sql serverÖÐinºÍexistsµÄÐ¡Çø±ð oracleδ²âÊÔ

in µÄ»°£¬ Èç¹ûÊÇnull ¾Í²»±È½ÏÁË£¬¼È²»ÊÇin Ò²²»ÊÇ not in
existsµÄ»° ÒòΪÓà = ¼ÓÔÚÌõ¼þÀï±È½ÏÁË£¬ËùÒÔ null ÊÇ not exists
select *
from pricetemp
where cast(ÉÌÆ·¥³ー¥É as varchar(10))not in(
           select shohin_cd
  &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ