PL/SQL Developer综合汇总

一、配置pl/sql developer连接管理Oracle数据库：

安装好Oracle后，找到安装目录下的tnsnames.ora文件：

D:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora

打开编辑配置：

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

CMFUDV1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.97.190.14)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cmfudv1)
    )
  )

CMFUDV_47 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.97.190.14)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cmfudv1)
    )
  )

打开pl/sql developer登陆：