PL/SQL Developer -> 下载 -> 安装 ->执行SQL -> 设置本地/远程连接

一 下载

点击进入 https://www.allroundautomations.com/bodyplsqldevreg.html

二 安装

4wkf7lzcb8amvke2rzeuclnk5emcwm5nzb

147724

xs374ca

三 汉化

点击进入 https://www.allroundautomations.com/bodyplsqldevreg.html

四 连接并执行SQL

五 设置

六 远程连接

需要下载个压缩包,点击进入https://www.oracle.com/database/technologies/instant-client/downloads.html




tnsnames.ora


环境变量1 固定写法

NLS_LANG
AMERICAN_AMERICA.ZHS16GBK

环境变量2
名称固定 内容:你解压的目录下的network admin

TNS_ADMIN
D:\Everything\PL_SQL_Developer\instantclient_19_3\network\admin

localhost@scott@123456 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )