PL/SQL

来源：互联网发布：美颜摄像头软件下载编辑：程序博客网时间：2024/06/06 03:37
 介绍
本来介绍有关PL/SQL使用方面的一些内容。 连接数据库
[caption id="attachment_5366" align="aligncenter" width="441"] pl_sql_oracle_logon[/caption]在使用PL/SQL连接数据库时，是需要对Oracle客户端进行配置的，上图中的Database列表项目就是下面的文件中定义的：%oracle_home%\app\ftp\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora[codesyntax lang="php"]# 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)    )  )
[/codesyntax]

查看原文：http://surenpi.com/2016/12/13/plsql/
0 0