-
介绍
本来介绍有关PL/SQL使用方面的一些内容。
-
连接数据库
在使用PL/SQL连接数据库时,是需要对Oracle客户端进行配置的,上图中的Database列表项目就是下面的文件中定义的:
%oracle_home%\app\ftp\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
# tnsnames.ora Network Configuration File: D:\oracle\app\ftp\product\12.1.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) FJ_A_133.146 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.146)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) ) |