Oracle client and PL/SQL connection Configuration

Source: Internet
Author: User


-----------------------------------

First, preface

Second, the environment

Third, Oracle Client Installation

Iv. Oracle Client Configuration

V. PL/SQL connection

-----------------------------------



First, preface

PL/SQL is a database language that is formed by Oracle's expansion of the standard SQL language. It is pinned to the traditional SQL statements, but also in the function of a lot of expansion. PL/SQL has too many advantages, and even makes it a bit of a shame. PL/SQL Developer is an integrated development environment designed to develop, test, debug, and optimize Oracle PL/SQL Storage program units such as triggers.

PL/SQL Developer This database development environment is fully functional, greatly reducing the programmer's development cycle. Powerful PL/SQL editor, complete Debugger debugger. Although the function of PL/SQL Developer is far less than that of Developer, it is an ORACLE database management tool developed with pure JAVA, so it is easier to support cross-OS platforms and can be used on non-Windows OS. Because PL/SQL Developer in Linux WINE is not very good, can not directly call the Linux OCI library, so if it is a Linux user, then you can only choose to use SQL Developer.

I hope this feature is very perfect PL/SQL Developer can bring convenience to the general developers.


Second, the environment

System: Win7 64-bit

Software and version:

10201_client_win32

plsqlV8.0.0.1480


Third, Oracle Client Installation

first, you need to install and configure the Oracle Client

When installing, be careful to select an administrator and then complete the next step.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4B/34/wKiom1QospWyysaEAAICczwz2cc111.jpg "title=" Untitled 001.png "alt=" Wkiom1qospwyysaeaaicczwz2cc111.jpg "/>

The following is no longer, always next!

Finally, if no special needs, choose to perform a typical configuration , and then complete the installation!


Iv. Oracle Client Configuration

Locate the installed Oracle client program in all programs.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4B/36/wKioL1Qos27z55MqAAFPaOC5ZJQ038.jpg "title=" Untitled 002.png "alt=" Wkiol1qos27z55mqaafpaoc5zjq038.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4B/34/wKiom1QoshiBBFFBAAG6LFuBc6E611.jpg "title=" Untitled 11.png "alt=" wkiom1qoshibbffbaag6lfubc6e611.jpg "style=" float:none; "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4B/35/wKiom1QotGDhVa1MAAH_dxLQiZo663.jpg "style=" float: none; "Title=" Untitled 003.png "alt=" Wkiom1qotgdhva1maah_dxlqizo663.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/35/wKiom1QotGLTrOSoAAHdH6wgJEc882.jpg "style=" float: none; "Title=" Untitled 004.png "alt=" Wkiom1qotgltrosoaahdh6wgjec882.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/38/wKioL1QotI7DawbWAAHl23ai8h8362.jpg "style=" float: none; "Title=" Untitled 005.png "alt=" Wkiol1qoti7dawbwaahl23ai8h8362.jpg "/>

The port number differs from Oracle server.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/35/wKioL1Qosj3girO4AAHPcwXbra8934.jpg "style=" float: none; "Title=" Untitled 04.png "alt=" Wkiol1qosj3giro4aahpcwxbra8934.jpg "/>

for connection testing.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/34/wKiom1QoshTh-uuXAAGX8nXI_HY382.jpg "style=" float: none; "Title=" Untitled 05.png "alt=" Wkiom1qoshth-uuxaagx8nxi_hy382.jpg "/>

If the test fails, change the login and change the password.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4B/36/wKioL1Qosj_R9gowAAGs_QP8LFc175.jpg "style=" float: none; "Title=" Untitled 06.png "alt=" Wkiol1qosj_r9gowaags_qp8lfc175.jpg "/>

Re-test, success.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4B/34/wKiom1Qoshby3a7zAAGLy8Uhsh0760.jpg "style=" float: none; "Title=" Untitled 08.png "alt=" Wkiom1qoshby3a7zaagly8uhsh0760.jpg "/>

Configuration is complete.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/34/wKiom1Qoshijlho0AAFK03rg7E8635.jpg "style=" float: none; "Title=" Untitled 10.png "alt=" Wkiom1qoshijlho0aafk03rg7e8635.jpg "/>


To view the configuration file (different from the installation directory):

# tnsnames.ora Network configuration file:c:\oracle\network\admin\tnsnames.ora# Generated by Oracle configuration Tools . ORCL = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.246.147.3) (PORT = 1522)) (CON Nect_data = (service_name = ORCL)))


V. PL/SQL connection

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/36/wKioL1QoskOSKlagAAEBsaTI5Jk107.jpg "style=" float: none; "Title=" Untitled 13.png "alt=" Wkiol1qoskosklagaaebsati5jk107.jpg "/>

Simply find a table, select "Query data" to execute the SQL statement, and you can create a table within it.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4B/33/wKiom1QoshHwnL5dAAKNt8Y5PkA081.jpg "title=" Untitled 01.png "style=" Float:none; "alt=" wkiom1qoshhwnl5daaknt8y5pka081.jpg "/>

Execute Query statement

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4B/35/wKioL1Qosjuger8HAAW2no2G1NU911.jpg "title=" Untitled 02.png "style=" Float:none; "alt=" wkiol1qosjuger8haaw2no2g1nu911.jpg "/>


650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4B/33/wKiom1QoshHwnL5dAAKNt8Y5PkA081.jpg "title=" Untitled 01.png "alt=" wkiom1qoshhwnl5daaknt8y5pka081.jpg "style=" float:none; "/>

Select and View in to query the statement when the table is created.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4B/34/wKiom1QoshLwEZbyAAIaeZTjOMQ928.jpg "title=" Untitled 03.png "style=" Float:none; "alt=" wkiom1qoshlwezbyaaiaeztjomq928.jpg "/>

This article is from the "Promise" blog, make sure to keep this source http://yinuoqianjin.blog.51cto.com/8360868/1559238

Oracle client and PL/SQL Connection Configuration

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.