Home > Database > Oracle > How to use PLSQL to connect to oracle database?

How to use PLSQL to connect to oracle database?

coldplay.xixi
Release: 2020-07-17 16:33:01
Original
13481 people have browsed it

How to use PLSQL to connect to the oracle database: first download the oracleclient client tool; then open PLSQL, click Cancel, and find the tools in the menu bar and select the attribute preferences to enter; then configure the oracleclient; finally restart PLSQL to enter .

How to use PLSQL to connect to oracle database?

How to use PLSQL to connect to the oracle database:

1. First download the oracleclient client tool

The editor has already downloaded it here. The directory structure is as follows

How to use PLSQL to connect to oracle database?

2. Open PLSQL, click Cancel to enter, and then the PLSQL main interface will pop up and find the menu bar. Tools, select the attribute preferences and go in

How to use PLSQL to connect to oracle database?

How to use PLSQL to connect to oracle database?

How to use PLSQL to connect to oracle database?

##3. The following interface pops up and configure oracleclient

Configure the two setting items, click apply, then click ok, close PLSQL, and restart PLSQL

How to use PLSQL to connect to oracle database?

4. The two fill-in items above are the first step. directory, and a file in the directory

As shown in the figure below, just find the corresponding directory.

How to use PLSQL to connect to oracle database?

5. Restart PLSQL to enter the login interface, enter relevant information, user name and password, and connection information

Connection information: can be ip:1521/ The instance name

can also be the TNS alias configured in tnsname.ora in the network/admin directory.

How to use PLSQL to connect to oracle database?

6. After the connection is successful

You can write a random statement to check whether it is normal

select * from dual;
Copy after login

How to use PLSQL to connect to oracle database?

Related learning recommendations:

oracle database learning tutorial

The above is the detailed content of How to use PLSQL to connect to oracle database?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template