PL/SQL 使用

1. 安装

    (1) 安装Oracle客户端

    (2) 在Oracle客户端目录(假设 c:\oraclient)下创建两个文件: "sqlnet.ora", "tnsnames.ora"，内容如下

          sqlnet.ora:                   

          SQLNET.AUTHENTICATION_SERVICES = (NTS)
          NAMES.DIRECTORY_PATH = (TNSNAMES)         

          tnsnames.ora:

MYDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.201)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = mydb1)
    )
  )

    (3) 配置环境变量

             变量：TNS_ADMIN

             值：    c:\oraclient

    (4) PL/SQL设置

              tools -> preferences

                 Oralce Home: c:\oraclient

                 Oracle Library:  "c:\oraclient\\oci.dll"