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 (
相关文档：
1 ，对于日期字段字段
access表示为：#1981-28-12#
SQLSERVER2000表示为：''1981-02-12''
2,SQL语句区别，select ,update 在对单表操作时都差不多，
但多表操作时update语句的区别ACCESS与SQLSERVER中的Update语句对比:
SQLSERVER中更新多表的Update语句:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
import java.sql.*;
/*
* JAVA连接ACCESS，SQL Server,MySQL,Oracle数据库
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====连接ACCESS数据库 ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. 执行sql语句
int sqlite3_exec(sqlite3*， const char *sql， sqlite3_callbacksql 语法
， void *， char **errmsg );
这就是执行一条 sql 语句的函数。
第1个参数不再说了，是前面open函数得到的指针。说了是关键数据结构。
第2个参数const char ......
father表 son表
fid fname sid sname fid height money
1 a 100 s1 1 1.7 7000
2 b 101 s2 2 1.6 8000
3 c 102&nbs ......
Creating a Sample Installation that Creates a SQL Server Database by Running Customized SQL Script
InstallShield 2009
用自定义的SQL脚本创建SQL Server数据库安装例子
Project 项目
This information applies to the following project types: 此信息是用于下面的项目类型
• Basic MSI
&b ......
