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

Oracle SQL Loader

Ò»£ºSQL Loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµã£¬±ÈÈçÔÚ²»Í¬°æ±¾Êý¾Ý¿âÖ®¼äµÄµ¼³ö¡¢µ¼ÈëµÄ¹ý³ÌÖ®ÖУ¬×Ü»á³öÏÖÕâÑù»òÕßÄÇÑùµÄÎÊÌ⣬Õâ¸öÒ²ÐíÊÇoracle¹«Ë¾×Ô¼º²úÆ·µÄ¼æÈÝÐÔµÄÎÊÌâ°É¡£
sql loader ¹¤¾ßȴûÓÐÕâ·½ÃæµÄÎÊÌ⣬Ëü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶ÔblobµÈÀàÐ͵ÄÊý¾Ý¾ÍÓеãÂé·³ÁË¡£
¶þ. sqlldr °ïÖú£º
C:\Documents and Settings\David>sqlldr
SQL*Loader: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 7ÔÂ 2 08:54:06 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Ó÷¨: SQLLDR keyword=value [,keyword=value,...]
ÓÐЧµÄ¹Ø¼ü×Ö:
    userid -- ORACLE Óû§Ãû/¿ÚÁî
   control -- ¿ØÖÆÎļþÃû
       log -- ÈÕÖ¾ÎļþÃû
       bad -- ´íÎóÎļþÃû
      data -- Êý¾ÝÎļþÃû
   discard -- ·ÏÆúÎļþÃû
discardmax -- ÔÊÐí·ÏÆúµÄÎļþµÄÊýÄ¿         (È«²¿Ä¬ÈÏ)
      skip -- ÒªÌø¹ýµÄÂß¼­¼Ç¼µÄÊýÄ¿  (ĬÈÏ 0)
      load -- Òª¼ÓÔØµÄÂß¼­¼Ç¼µÄÊýÄ¿  (È«²¿Ä¬ÈÏ)
    errors -- ÔÊÐíµÄ´íÎóµÄÊýÄ¿         (ĬÈÏ 50)
      rows -- ³£¹æÂ·¾¶°ó¶¨Êý×éÖлòÖ±½Ó·¾¶±£´æÊý¾Ý¼äµÄÐÐÊý
               (ĬÈÏ: ³£¹æÂ·¾¶ 64, ËùÓÐÖ±½Ó·¾¶)
  bindsize -- ³£¹æÂ·¾¶°ó¶¨Êý×éµÄ´óС (ÒÔ×Ö½Ú¼Æ)  (ĬÈÏ 256000)
    silent -- ÔËÐйý³ÌÖÐÒþ²ØÏûÏ¢ (±êÌâ,·´À¡,´íÎó,·ÏÆú,·ÖÇø)
    direct -- ʹÓÃÖ±½Ó·¾¶      &nb


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

Oracle ²éѯ²¢É¾³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä


²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)
 
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......

SQLÖ® case when then

 ÊÓͼ²éѯÖÐÔõÑù½«Ô­¶¨ÓÚÈçÐÔ±ðsex ÕâÑùµÄ×ֶΣ¬×Ö¶ÎֵΪ0£¬1ÕâÑùµÄintÀàÐÍÖµ£¬²éѯʱֱ½Ó·µ»Øvarchar
Ð͵Ä×Ö·û‘ÄÐ’£¬‘Å®’ÒÔ±ãÓÚÎÒÃǶÁÈ¡ÄØ£¿
      
ÓÐÈË»áÏëµ½if …else…ÕâÑùµÄÓï¾ä£¬¿ÉÊÇÔõô¼Ó£¬¶¼²»ÖªµÀ¼ÓÄÄÀÒòΪ×ÜÊÇ»á³ö´í¡£Æä ......

SQL×¢Èë½Ì³ÌÖ®ÈëÃÅÆª

Èë Êƪ
Èç¹ûÄãÒÔǰûÊÔ¹ýSQL×¢ÈëµÄ»°£¬ÄÇôµÚÒ»²½ÏȰÑIE²Ëµ¥=>¹¤¾ß=>InternetÑ¡Ïî=>¸ß¼¶=>ÏÔʾÓѺà HTTP ´íÎóÐÅÏ¢Ç°ÃæµÄ¹´È¥µô¡£·ñÔò£¬²»ÂÛ·þÎñÆ÷·µ»ØÊ²Ã´´íÎó£¬IE¶¼Ö»ÏÔʾΪHTTP 500·þÎñÆ÷´íÎ󣬲»ÄÜ»ñµÃ¸ü¶àµÄÌáʾÐÅÏ¢¡£
µÚÒ»½Ú¡¢SQL×¢ÈëÔ­Àí
ÒÔÏÂÎÒÃÇ´ÓÒ»¸öÍøÕ¾www.19cn.com¿ªÊ¼£¨×¢£º±¾ÎÄ·¢±íǰÒÑÕ÷µ ......

SQL×¢Èë½Ì³ÌÖ®¸ß¼¶Æª

¿´ÍêÈëÃÅÆªºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆÆ½âÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËÒ»Ð©ÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿ÔõôÑùÌá¸ß²Â½âЧÂÊ£¿Çë´ó¼Ò½Ó×ÅÍùÏ¿´¸ß¼¶Æª¡£
µÚÒ»½Ú¡¢ÀûÓÃϵͳ±í×¢ÈëSQLServerÊý¾Ý¿â
SQLServerÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âϵͳ£¬Óë²Ù×÷ϵͳҲÓнôÃܵÄÁªÏµ£¬Õâ¸ø¿ª·¢Õß´øÀ´ÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ