VBA使用总结（Oracle使用）

■通过Oracle DB_Link复制数据

delete from <table_name>@<dbLinkName>

insert into <table_name>@<dbLinkName> select * from <table_user>.<table_name>

 

<table_name>，<dbLinkName>，<table_uer>需替换为具体名称

 

■Oracle数据库显示乱码问题

Database character set

 

SQL> conn / as sysdba;

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter system enable restricted session;

SQL> alter system set job_queue_processes=0;

SQL> alter system set aq_tm_processes=0;

SQL> alter database open;

SQL> alter database character set internal_use AL32UTF8;(ZHS16GBK)

SQL> shutdown immediate;

SQL> startup;

 

http://www.soidc.net/articles/1213781343264/20091019/1215945666391_1.html

 

Client character set （修改注册表）

 

HKEY_LOCAL_MACHINE\SOFTEARE\ORACLE\Key_OraDb10g_home1

NLS_LANG=AMERICAN_AMERICA.AL32UTF8

 

■SQL Loader使用

http://www.orafaq.com/wiki/SQL%2ALoader_FAQ

 

Contents

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?

 

关于 Oracle 的数据导入导出及 Sql Loader (sqlldr) 的用法

http://www.cnblogs.com/flish/archive/2010/05/31/1748221.html

 

Oracle FAQ

http://www.orafaq.com/wiki/Category:Frequently_Asked_Questions