plsql不安装oracle客户端连接oracle数据库
1.解压oracleclient.x64.zip 配置对应环境变量
2.打开plsql配置oraclehome
plsql --> Tools --> Preferences
D:\BaiduNetdiskDownload\oracleclient.x64\oracleclient\instantclient_19_3
D:\BaiduNetdiskDownload\oracleclient.x64\oracleclient\instantclient_19_3\oci.dll
文档:plsqldeveloper.zip
链接:http://note.youdao.com/noteshare?id=6a0ef378b00d9a7ec2ceccf14496099d&sub=DAFB32BD60D440279257EAB34261A93E
文档:oracleclient.x64.zip
链接:http://note.youdao.com/noteshare?id=2bdff67b8af38e6fd7daac9ab760e3a0&sub=69725340D672461796557E45075CA6FD
如果查询中文乱码
select userenv('language') from dual;
查询字符集规则配置电脑环境变量
注意一定是 NLS_LANG 名字不要是其他