²ËÄñ¹ØÓÚÊý¾Ýµ¼ÈëOracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
1¡¢½«ACCESSÖеÄÒ»¸ö±íµ¼³öΪasd.txtºó£¬·ÅÔÚ×ÀÃæÉÏ£¬ÔÚCMD.EXEÖÐÔËÐÐ
C:\Documents and Settings\Administrator>type asd.txt
ÀÏÌáʾ¡°ÏµÍ³ÕÒ²»µ½Ö¸¶¨Îļþ¡±¡£
2¡¢ÁíÍ⣬ÇëÎÊload1.ctlÕâ¸ö¿ØÖÆÎļþÊÇÔÚʲô»·¾³ÏÂдµÄ£¿ÎÒÏÈÊÇÔÚ.txtÎļþÖÐд
load data
infile 'asd.txt'
into table asd
fields terminated by "," optionally enclosed by '"'
(col1,col2)
ÕâЩÓï¾ä,È»ºó°Ñºó׺.txtÖ±½Ó¸Ä³É.ctl¡£È»ºóÔÙÔÚCMD.EXEÖÐÔËÐÐ
C:\Documents and Settings\Administrator>sqlldr userid=scott/tiger control=load1.ctl
ÀÏÊÇÌáʾÎļþ²»´æÔÚ¡£
Çë¸ßÊÖ¾ÍÉÏÃæÁ½¸öÎÊÌâ¼°aqlloaderµÄʹÓò½ÖèÖ¸µãÒ»¶þ£¬Ð»ÁË£¡
Documents and Settings Óпոñ£¬¹À¼Æ²»Ö§³Ö
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......