SQL*Loader FAQ
转自：http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_can_one_get_SQL.2ALoader_to_COMMIT_only_at_the_end_of_the_load_file.3F
Contents
[hide
]
1
What is SQL*Loader and what is it used for?
2
How does one use the SQL*Loader utility?
3
How does one load MS-Excel data into Oracle?
4
Is there a SQL*Unloader to download data to a flat file?
5
Can one load variable and fixed length data records?
6
Can one skip header records while loading?
7
Can one modify data as the database gets loaded?
8
Can one load data from multiple files/ into multiple tables at once?
9
Can one selectively load only the records that one needs?
10
Can one skip certain columns while loading data?
11
How does one load multi-line records?
12
How does one load records with multi-line fields?
13
How can one get SQL*Loader to COMMIT only at the end of the load file?
14
Can one improve the performance of SQL*Loader?
15
What is the difference between the conventional and direct path loader?
16
How does one use SQL*Loader to load images, sound clips and documents?
17
How does one load EBCDIC data?
[edit
]
What is SQL*Loader and what is it used for?
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database
. Its syntax is similar to that of the DB2
load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.
SQL*Loader (sqlldr) is the utility to use for high
performance data loads. The data can be loaded from any text file and
inserted into the database.
[edit
]
How does one use the SQL*Loader utility?
One can load data into an Oracle database by using the sqlldr (sqlload on some platforms) utility. Invoke the utility without arguments to get a list of available parameters. Look at the following example:
sqlldr username@server/password control=loader.ctl
sqlldr username/password@server control=loader.ctl
This sample control file (
相关文档：
熟悉SQL SERVER 2000的数据库管理员都知道，其DTS可以进行数据的导入导出，其实，我们也可以使用Transact-SQL语句进行导入导出操作。在Transact-SQL语句中，我们主要使用OpenDataSource函数、OPENROWSET 函数，关于函数的详细说明，请参考SQL联机帮助。利用下述方法，可以十分容易地实现SQL SERVER、ACCESS、EXCEL数据转换� ......
--函数如下：
/*
CREATE FUNCTION dbo.fnpbGetPYFirstLetter
(
@str NVARCHAR(4000)
)
RETURNS NVARCHAR(4000)
--WITH ENCRYPTION
AS
BEGIN
DECLARE @WORD NCHAR(1),@PY NVARCHAR(4000)
SET @PY=''
WHILE LEN(@STR)>0
BEGIN
SET @WORD=LEF ......
//在应用程序Open 事件代码中
idle(600)
openbakflag=1
///////////////////////读取配置文件数据库连接设置///////////////////////
string server,datname,datuser,datpsw
server=ProfileString ( "yy.ini","yygl","server", "" )
datname=ProfileString ( "yy.ini","yygl","datname", "" )
datuser=ProfileStrin ......
今天又看到新加坡的同事发过来的一段SQL语句，还是老问题，时间对比直接用大于小于号。叹了声气后，手动给改成datediff了，可是一运行出错，错误提示如下：
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting datetime from character string.
为了说明方便，这里就简化一个例子好了。
create tab ......
