1.下載對(duì)于oracle數(shù)據(jù)庫(kù)對(duì)于版本的instantclient_11_2

oracle11g下載地址：https://www.oracle.com/technetwork/topics/winx64soft-089540.html

2.將文件解壓出來D:\Documents\plsqldoc\instantclient_11_2

3.在D:\Documents\plsqldoc\instantclient_11_2下新建tnsnames.ora 文件。路徑D:\Documents\plsqldoc\instantclient_11_2\tnsnames.ora

4.新建 tnsnames.ora 文件里面加入

# tnsnames.ora Network Configuration File: D:\Documents\plsqldoc\instantclient_11_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )  
ORCL2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IPHOME )(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

5.IPHOME數(shù)據(jù)庫(kù)所在的地址，本機(jī)填localhost

6.之后在計(jì)算機(jī)——屬性——高級(jí)系統(tǒng)設(shè)置——高級(jí)——環(huán)境變量——系統(tǒng)變量，中新建

變量名：TNS_ADMIN

變量值：D:\Documents\plsqldoc\instantclient_11_2

變量值寫填自己 tnsnames.ora 文件所在的路徑

7.修改PLSQL查詢結(jié)果亂碼(???)

變量名：NLS_LANG

變量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

8.系統(tǒng)變量 —— Path中加入D:\Documents\plsqldoc\instantclient_11_2

instantclient_11_2對(duì)于自己電腦所在的路徑

9.PLSQL中——工具——首選項(xiàng)——連接

ORCALE中目錄：D:\Documents\plsqldoc\instantclient_11_2

OCI庫(kù)：D:\Documents\plsqldoc\instantclient_11_2\oci.dll

以上就是動(dòng)力節(jié)點(diǎn)小編介紹的"超詳細(xì)解決PLSQ數(shù)據(jù)庫(kù)下拉為空"，希望對(duì)大家有幫助，想了解更多可查看Java在線學(xué)習(xí)。動(dòng)力節(jié)點(diǎn)在線學(xué)習(xí)教程，針對(duì)沒有任何Java基礎(chǔ)的讀者學(xué)習(xí),讓你從入門到精通,主要介紹了一些Java基礎(chǔ)的核心知識(shí)，讓同學(xué)們更好更方便的學(xué)習(xí)和了解Java編程，感興趣的同學(xué)可以關(guān)注一下。