VBA使用总结（Oracle使用）_oracle cloud vba-优快云博客

■通过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?

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

Oracle FAQ

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

VBA使用总结（Oracle使用）