1.设置格式还快捷键如下图(其他快捷键也可以在此设置,这个看个人):
2.tnsnames.ora配置
1.下载 instantclient版本(我下载的是instantclient_12_2)
2.在即时客户端的目录里新建文件夹 network ,network里在新建 admin,在admin目录下建一个后缀名为.ora的文件:tnsnames.ora
tnsnames.ora添加如下 host 地址 PORT 端口
# tnsnames.ora Network Configuration File: D:\oracle\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
)
test-name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
3.Oracle 主目录名:填写Oracle安装的目录
4.OCI库:填写文件路径加/oci.dll