Oracle SQL*LoaderÊý¾Ý×°ÔØ
SQL*Loader ÓÃÓÚ½«´óÁ¿Êý¾Ý×°ÈëÊý¾Ý¿â¡£
¢Å¡¢¶¨¿íÊý¾Ý
´´½¨Êý¾ÝÎļþcontrol.txt£º
aaa,bbb
ccc,ddd
eee,fff
´´½¨¿ØÖÆÎļþcontrol.ctl£º
load data
infile 'c:\loader.txt'
append
into table tester.mm(
m1 position(1:3) char,
m2 position(5:7) char)
ÅúÁ¿¼ÓÔØÊý¾Ý£º
sqlldr tester/test control=c:\loader.ctl data=c:\loader.txt
¢Æ¡¢¶¨½ç·ûÊý¾Ý
´´½¨Êý¾ÝÎļþcontrol.txt£º
abc|def,xyz
a,bbb
cc,ddd
eee-dd,fff-le
´´½¨¿ØÖÆÎļþcontrol.ctl£º
load data
infile 'c:\loader.txt'
append
into table tester.mm(
m1 char terminated by ",",
m2 char terminated by ",")
ÅúÁ¿¼ÓÔØÊý¾Ý£º
sqlldr tester/test control=c:\loader.ctl data=c:\loader.txt
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¸ú×ÅÕ⼸ÌìOracle OpenWorld´ó»áµÄ¾ÙÐУ¬Oracle11gµÄÐÂÌØÕ÷Ô½À´Ô½¶àµÄ±»Õ¹ÏÖ³öÀ´¡£
¡¡¡¡ÒÔÇ°£¬ÎÒÔø¾Òý¼û¹ýOracle11g½«¿ÉÄÜÔÚ10Ô·ݵÄÕâ¸ö´ó»áÉÏÍƳö£¬µ±³õÖÁÓÚAlpha°æµÄÐÅÏ¢ÒѾ¿ÉÒÔ¼ûµ½£¬ÏÖʱ³öÏÖµÄÒѾÊÇBeta°æ£¬ÀëOracle11gµÄÕýʽ°æÒѾ²»Ô¶¡£
¡¡¡¡Laurent Schneider ÔÚËûµÄBlogÖÐ̸µ½£¬¶ÔÓÚOracle11gµÄÃû×Ö»¹ ......
¶þÁãÁã¾ÅÄêʮԶþÊ®ÈÕ£¬´ò´ÓÈýÄêÇ°ÍƳöOracle¼Ó½ô¼Æ»®ÒÔÀ´£¬¼×¹ÇÎĹ«Ë¾ÒѾÔö¼ÓÁËÆß,000¶à¼ÒÖÎÀíÈí¼þÖÐÐÍÆóÒµ¿Í»§£¬µ±Ç°ÖÐÐÍÆóÒµ¿Í»§×ÜÁ¿ÒѾ³¬¹ý25,000¼Ò¡£
͸¹ýÍƳöÂíÏòÖÐÐÍÆóÒµ¿Í»§µÄOracle¼Ó¿ì¼Æ»®Ð¹¦ÄÜ£¬°üÀ¨ÐÂʽ¼Ó¿ì¼Æ»®½â¾ö·½°¸¡¢OracleÆóÒµ¼ÓËÙÆ÷¡¢²ÆÎñÑ¡¼þºÍµ÷¶È²½ÖèµÈ£¬¼×¹ÇÎÄÔÚ²»Í£¶ÒÏÖ˳Àû¡£
ÃæÁÙÖÐÐÍ ......
SELECT * from user WHERE name LIKE '%Èý%';
½«»á°ÑnameΪ“ÕÅÈý”£¬“Èý½Å蔣¬“ÌÆÈý²Ø”µÈµÈÓГÈý”µÄÈ«ÕÒ³öÀ´£»
ÔÚ½øÐÐÊý¾Ý¿â²éѯʱ£¬ÓÐÍêÕû²éѯºÍÄ£ºý²éѯ֮·Ö¡£
Ò»°ãÄ£ºýÓï¾äÈçÏ£º
SELECT ×ֶΠfrom ±í WHERE ij×ֶΠLike Ìõ¼þ
ÆäÖйØÓÚÌõ¼þ£¬SQLÌṩÁËËÄÖÖÆ¥ÅäÄ£Ê ......