rection varchar2(100),
9 long_degrees number,
10 long_minutes number,
11 long_seconds number,
12 long_direction varchar2(100));
表已创建。
SQL> host sqlldr hr/hr control=c:\data\loader.ctl log=c:\data\load.log;
SQL*Loader: Release 10.2.0.1.0 - Production on 星期二 8月 12 16:42:57 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
达到提交点 - 逻辑记录计数 2
SQL> select * from michigan_features;
行将被截断
FEATURE_NAME
--------------------------------------------------------------------------------
"Wagner Falls"
"Tannery Falls"
3，使用sql 表达式， 在这个例子中使用了to_number 函数， 同样可以使用自定义的函数
LOAD DATA
INFILE *
REPLACE INTO TABLE book
fields terminated by "," optionally enclosed by '"'
(
book_title ,
book_price
"GREATEST(TO_NUMBER(:book_price)/100 * TO_NUMBER(:book_pages*0.10))",
book_pages
)
Begindata
Oracle Essentials ,3495,355
SQL*Plus: The Definitive Guide ,3995,502
Oracle PL/SQL Programming ,4495,87
Oracle8 Design Tips ,1495,115
例子：
SQL> create table BOOK
2 (
3 BOOK_ID NUMBER,
4 BOOK_TITLE VARCHAR2(35),
5 BOOK_PRICE NUMBER,
6 BOOK_PAGES NUMBER
7 );
表已创建。
SQL> sqlldr hr/hr control =c:\data\loader.ctl log=c:\data\log.log
SP2-0734: 未知的命令开头 "sqlldr hr/..." - 忽略了剩余的行。
SQL> host sqlldr hr/hr control =c:\data\loader.ctl log=c:\data\log.log;
SQL*Loader: Release 10.2.0.1.0 - Production on 星期四 8月 14 09:19:03 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
达到提交点 - 逻辑记录计数 3
达到提交点 - 逻辑记录计数 4
SQL> select * from book;
BOOK_ID BOOK_TITLE BOOK_PRICE BOOK_PAGES
---------- ----------------------------------- ---------- ----------
Oracle Essentials 1240.725 355
SQL*Plus: The Definitive Guide 2005.49 502
Oracle PL/SQL Programming 391.065 87
Oracle8 Design Tips 171.925 115
SQL>
4，字符串转换：
The following LOAD statement provides an example of how to specify a character
set. In this case, the character set is an EBCDIC character set named
WE8EBCDIC37C. Look for the CHARACTERSET clause in the second line of the
LOAD command:
LOAD DATA
CHARACTERSET 'WE8EBCDIC37C'
INFILE 'book_prices.dat'
REPLACE INTO TABLE book
(
book_title POSITION(1) CHAR(35),
book_price POSITION(37)
"GREATEST(TO_NUMBER(:book_price)/100,
TO_NUMBER(:book_pages*0.10))",
book_pages POSITION(42) INTEGER EXTERNAL(3),
book_
由于权限不够，这里将本文分两部分发出，后续请看--Oracle SQL*Loader 使用指南（第二部分）
本文出自“小小狗窝”
|