oracleµ¼ÈëÎı¾Îļþ
1.ʹÓÃsqlldr
2.Ê×ÏȽ¨Á¢ÏàÓ¦µÄ±í
create table test(ip1 number, ip2 number, locate varchar2(512),country varchar2(60),province varchar2(60),city varchar2(60))
3.д¿ØÖÆÎļþ city.ctl
load data
infile 'c:\city.txt'
append into table test
--when country='Öйú'
fields terminated by ','
(
ip1,
ip2,
locate,
country,
province,
city
)
4.ͨ¹ýsqlldr¼ÓÔØÊý¾Ý
sqlldr user/pass@orcl251 control=c:\city.ctl log=c:\logfile.txt bad=c:\badfile.txt discard=c:\discardfile.txt
Ïà¹ØÎĵµ£º
ÓÃOracle9i×Ô´øµÄÆóÒµ¹ÜÀíÆ÷»òPL/SQLͼÐλ¯µÄ·½·¨´´½¨±í¿Õ¼äºÍÓû§ÒÔ¼°·ÖÅäȨÏÞÊÇÏà¶Ô±È½Ï¼òµ¥µÄ£¬±¾ÎÄÒª½éÉܵÄÊÇÁíÒ»ÖÖ·½·¨£¬Ê¹ÓÃOracle 9iËù´øµÄÃüÁîÐй¤¾ß£ºSQLPLUSÀ´´´½¨±í¿Õ¼ä£¬Õâ¸ö·½·¨ÓÃÆðÀ´¸ü¼Ó¼òÃ÷¿ì½Ý¡£
¼ÙÉè ......
ÒÔǰÓиöÏîÄ¿½«Óû§±í½¨Á¢ÔÚÁËsystemÓû§ËùÊôÏ£¬ºóÀ´·¢¾õΣº¦Ï൱´ó£¬×¼±¸½«±í¶ÔÏó×ªÒÆµ½Ð½¨Á¢µÄLANDÓû§Ï£¬Ã»ÕÒµ½Ö±½ÓµÄ°ì·¨£¬ÓÃÒÔϰ취µÃÒÔʵÏÖ£º
1¡¢½¨Á¢ÐµÄLANDÓû§£¬ÔÚ·þÎñÆ÷µÄOracle Enterprise ManagerÀï·ÖÅä ¶ÔÏóȨÏÞ £¬Ìí¼Ó¶ÔsystemÖÐÊý¾Ý±í¶ÔÏóµÄ select ȨÏÞ¡£
2¡¢ÒÔ LAND Óû§µÇ¼£¬Ê¹ÓÃÃüÁ ......
The following are number examples for the to_char
function.
to_char
(1210.73,
'9999.9')
would return '1210.7'
to_char
(1210.73,
'9,999.99')
would return '1,210.73'
to_char
(1210.73,
'$9,999.00')
would return
'$1,210.73'
to_char
(21,
'000099')
would return '000021'
The foll ......
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25 ......