用PL/SQL的连接数据库的几种方式
方案1:
通过过在 tnsnames.ora文件配置。
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
CPIC_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.138.97.189)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =cpic)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.138.97.189)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =cpic)
)
)