【六袆 - Windows】PL/SQL instantclient安装包下载；PL/SQL双击登录配置

安装 PL/SQL 15

OMIT

Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit

https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

配置

# tnsnames.ora Network Configuration File:
 E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


ocrl =
  (DESCRIPTION=
      (ADDRESS=(PROTOCOL=TCP) (HOST=192.168.12.223)(PORT=1521))
  (CONNECT_DATA=
       (SERVICE_NAME=ocrl)
    )
  )
1
2
3
4
5
6
7
8
9
10
11
12

一键登录

在快捷键加上参数

"F:\Program Files\PLSQL Developer 14\plsqldev.exe" userid=username/password@orcl
1

这样双击，不需要每次都填密码，直接登录