1.下载oracle instant client(作为本地oracle环境)
下载地址:
https://www.oracle.com/database/technologies/instant-client/downloads.html
根据自己的电脑选择32位或64位
2.下载完后解压到PL/SQL安装目录下![在这里插入图片描述](https://img-blog.csdnimg.cn/20201012100702216.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTQ5NjY5MA==,size_16,color_FFFFFF,t_70#pic_center)
在instantclient_19_8下创建instantclient_19_8\network\ADMIN 这两个文件夹
在ADMIN下创建文件tnsnames.ora
打开文件添加
xxxx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = **.**.**.**)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = corcl)
)
)
3.打开PL/SQL
选择 配置 > 首选项 > 连接
OCI库选择具体路径 D:\PLSQL\instantclient_19_8\oci.dll