PL/SQL Developer 13 格式化、执行快捷键设置 、tnsnames.ora配置

 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