pl mysql安装_Windows PLSQL的安装、配置与使用

PLSQL下载：http://www.what21.com/sys/view/oracle_oracle-basis_1456896297650.html

Oracle Instant Client下载 : http://www.what21.com/sys/view/oracle_2_1496745513993.html

http://www.oracle.com/technetwork/cn/database/features/instant-client/index-097480.html

PLSQL安装目录：E:\MyApps\MyRunTools\PLSQLDeveloper7\PLSQLDeveloper7

Oracle Instant Client：E:\MyApps\MyRunTools\PLSQLDeveloper7\instantclient_11_2

菜单： Tools -> Connection ->

Oracle Home(empty is autodetect)

E:\MyApps\MyRunTools\PLSQLDeveloper7\instantclient_11_2

OCI library(empty is autodetect)

E:\MyApps\MyRunTools\PLSQLDeveloper7\instantclient_11_2\oci.dll

配置连接：

E:\MyApps\MyRunTools\PLSQLDeveloper7\instantclient_11_2\NETWORK\ADMIN\tnsnames.oraORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

PLSQL乱码配置：

设置本地环境变量(PLSQL优先从环境变量中获取属性)

右击 我的电脑 -> 属性 -> 高级系统设置 -> 高级 -> 环境变量 -> 系统变量-> 新建系统变量

新增如下两条记录：

NLS_CHARACTERSET = ZHS16GBK

NLS_LANG = AMERICAN_AMERICA.ZHS16GBK

执行查询：

NLS_CHARACTERSET = ZHS16GBK

NLS_LANG = AMERICAN_AMERICA.ZHS16GBK