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

²ËÄñ¹ØÓÚÊý¾Ýµ¼Èë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 Óпոñ£¬¹À¼Æ²»Ö§³Ö


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ