本地没装oracle数据库,但是又想用plsqldeveloper
配置plsqldeveloper
1:下载 instantclient_11_2
2:在d:/instantclient_11_2目录下新建network,在network目录下新建admin目录,在admin目录下新建tnsnames.ora,然后编辑内容
3:添加一个环境变量,名为TNS_ADMIN,值为tnsnames.ora文件所在路径。比如我的本机为:D:/instantclient_11_2/network/admin
环境变量 NLS_LANG SIMPLIFIED CHINESE_CHINA.AL32UTF8
4:配置PLSQLdeveloper
配置tools->preferences->connection
Oracle Home
D:/instantclient_11_2
OCI library
D:/instantclient_11_2/oci.dll
5:查询oracle server端的字符集,可以用sqlplus登录oracle,然后select userenv(‘language’) from dual;
配置plsqldeveloper
1:下载 instantclient_11_2
2:在d:/instantclient_11_2目录下新建network,在network目录下新建admin目录,在admin目录下新建tnsnames.ora,然后编辑内容
3:添加一个环境变量,名为TNS_ADMIN,值为tnsnames.ora文件所在路径。比如我的本机为:D:/instantclient_11_2/network/admin
环境变量 NLS_LANG SIMPLIFIED CHINESE_CHINA.AL32UTF8
4:配置PLSQLdeveloper
配置tools->preferences->connection
Oracle Home
D:/instantclient_11_2
OCI library
D:/instantclient_11_2/oci.dll
5:查询oracle server端的字符集,可以用sqlplus登录oracle,然后select userenv(‘language’) from dual;