Oracle数据库之PL/SQL的”适配”新生
32位的PL/SQL在64的机子上无法连接64位的Oracle数据库。本来笔者已经放弃使用PL/SQL的，而是选择使用Oracle 的SQL Developer。可
两天真是有够郁闷的，原因无他，32位的PL/SQL在64的机子上无法连接64位的Oracle数据库。本来笔者已经放弃使用PL/SQL的，而是选择使用Oracle 的SQL Developer。可是老实说使用过PL/SQL之后真心不习惯用其他工具，而且Oracle应用开发基本都是使用PL/SQL的这真是让我坐立难安啊。
其实。PL/SQL如何连接64为的Oracle数据库网上已经给出答案了，但是起初自己按照其方法如何都不成功，真心流泪啊，也就尝试着用了两天其他工具。之后实在熬不住了，果断卯上了最后还是配置成功了!
现在将其记录下来，留给日后遇到同样尴尬问题的朋友一个借鉴！其实这个方法网上已经烂了
还是通过下载一个32位的客户端来实现的，感觉上和设计模式中的适配器十分像，我也就取名为这个了，别深究啊！
先来看看笔者的软件安装目录吧：
Oracle数据库主目录：D:\Oracle11g
32位的客户端主目录：D:\Oracle11g\instantclient_11_2
他们在同一个目录下
具体方法如下：
首先下载instantclient-basic-win32，将其解压缩，我将其拷贝到Oracle的同一个安装目录下：
参照笔者目录
下面打开PL/SQL Developer，注意不要登陆，找到主界面的工具/首选项/连接，分别填入如下所示内容：
Oracle主目录名：OraDb11g_home1
OCI库:D:\Oracle11g\instantclient_11_2\oci.dll
下面开始设置环境变量：
TNS_ADMIN：D:\Oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
其实配置不成功一般还是路径的问题（在服务已经启动，监听打开的情况下），笔者一开始也是路径除了一点问题。
看看成果吧：
这个界面一出来我就激动了，，终于是否要成功了，有那么一丝可能啊
OK！成功了
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1390
52
How to check which table space a table belongs to in Oracle
Jul 06, 2023 pm 01:31 PM
How to check which table space a table belongs to in Oracle: 1. Use the "SELECT" statement and specify the table name to find the table space to which the specified table belongs; 2. Use the database management tools provided by Oracle to check the table space to which the table belongs. Tools usually provide a graphical interface, making the operation more intuitive and convenient; 3. In SQL*Plus, you can view the table space to which the table belongs by entering the "DESCRIBEyour_table_name;" command.
How to connect to Oracle database using PDO
Jul 28, 2023 pm 12:48 PM
Overview of how to use PDO to connect to Oracle database: PDO (PHPDataObjects) is an extension library for operating databases in PHP. It provides a unified API to access multiple types of databases. In this article, we will discuss how to use PDO to connect to an Oracle database and perform some common database operations. Step: Install the Oracle database driver extension. Before using PDO to connect to the Oracle database, we need to install the corresponding Oracle
How to retrieve only one piece of duplicate data in oracle
Jul 06, 2023 am 11:45 AM
Steps for Oracle to fetch only one piece of duplicate data: 1. Use the SELECT statement combined with the GROUP BY and HAVING clauses to find duplicate data; 2. Use ROWID to delete duplicate data to ensure that accurate duplicate data records are deleted, or use "ROW_NUMBER" ()" function to delete duplicate data, which will delete all records except the first record in each set of duplicate data; 3. Use the "select count(*) from" statement to return the number of deleted records to ensure the result.
Implement data import into PHP and Oracle databases
Jul 12, 2023 pm 06:46 PM
Implementing data import into PHP and Oracle databases In web development, using PHP as a server-side scripting language can conveniently operate the database. As a common relational database management system, Oracle database has powerful data storage and processing capabilities. This article will introduce how to use PHP to import data into an Oracle database and give corresponding code examples. First, we need to ensure that PHP and Oracle database have been installed, and that PHP has been configured to
How to use php to extend PDO to connect to Oracle database
Jul 29, 2023 pm 07:21 PM
How to use PHP to extend PDO to connect to Oracle database Introduction: PHP is a very popular server-side programming language, and Oracle is a commonly used relational database management system. This article will introduce how to use PHP extension PDO (PHPDataObjects) to connect to Oracle database. 1. Install the PDO_OCI extension. To connect to the Oracle database, you first need to install the PDO_OCI extension. Here are the steps to install the PDO_OCI extension: Make sure
Does oracle database require jdk?
Jun 05, 2023 pm 05:06 PM
The oracle database requires jdk. The reasons are: 1. When using specific software or functions, other software or libraries included in the JDK are required; 2. Java JDK needs to be installed to run Java programs in the Oracle database; 3. JDK provides Develop and compile Java application functions; 4. Meet Oracle's requirements for Java functions to help implement and implement specific functions.
How to use PHP and Oracle database connection pools efficiently
Jul 12, 2023 am 10:07 AM
How to efficiently use connection pooling in PHP and Oracle databases Introduction: When developing PHP applications, using a database is an essential part. When interacting with Oracle databases, the use of connection pools is crucial to improving application performance and efficiency. This article will introduce how to use Oracle database connection pool efficiently in PHP and provide corresponding code examples. 1. The concept and advantages of connection pooling Connection pooling is a technology for managing database connections. It creates a batch of connections in advance and maintains a
How to query table space size in oracle
Jul 06, 2023 pm 01:45 PM
Steps to query the table space size in Oracle: 1. Log in to the Oracle database using a database administrator account; 2. Use the "SELECT" statement to view the space list; 3. There are three methods to query the table space size: use the dbms_utility package to query, and use the dba_segments view Query, use the dba_data_files view query; 4. Use the "DBMS_OUTPUT.PUT_LINE" function or other methods to display the results to display the query results.
