How to connect an Oracle database with PL/SQL developer

Prior to the project because of the need to use the Oracle database, due to limited time to start learning from the foundation, and Oracle operation of the command interface is too unfriendly, so found the PL/SQL developer This very useful software to use the database indirectly.

Here's a quick introduction to using this software to connect to an Oracle database.

The first step is to install Oracle database and PL/SQL Developer

There are many tutorials on the web that are not covered in detail. Oracle can go directly to the official website to download, in the installation of the attention of a few questions on the line:

1. Be sure to remember your global database name and password, which is important when connecting later.

2. There is also a need to note that at the end of the installation there will be a hint, the best point of opening management, you can see a lot of account related information, it is best to save, especially remember the system account information.

PL/SQL installation is more simple, there are many resources on the Internet after decompression can be directly used, if there are problems can Baidu.

The second step is to create a new user with SQL Plus

First find SQL Plus in the Start menu, if you can't find it.

Opening SQL Plus will remind you to enter your username and password, enter system and the appropriate password (this is especially emphasized in the previous step to remember).

After verification, connect to the database, and then use the following code to create a new user hahaha with a password of 123456:

Create user hahaha identified by 123456;

After entering, the user is created and the following code is used to give permission:

Grant CONNECT,RESOURCE,DBA to hahaha;

Upon completion

Third step to connect Oracle database with PL/SQL developer

Open the PL/SQL client and enter the following information

The account number and password is the new account password you just created, the database is the name you give to the total databases at the time of installation, click OK to connect.

If the connection is not on the Connection Agreement may be a problem, you need to modify the corresponding parameters in the configuration, this can be self-baidu a bit.

This problem does not occur if you have not previously installed Oracle and follow my steps step-by-step.

Attached: How to import files

Open cmd

First enter your data in the Bin folder (due to different computer and installation method, the path is not the same, you need to change), the code is as follows

Cd\app\username\product\11.2.0\dbhome_1\bin

You can then import the data into the database using the IMP command, for example:

Imp userid=hahaha/[email protected] full=y file=e:\data\his_20131124dmp.dmp

This command parameter 1 is the user and password to the database to be imported, parameter 2 is the meaning of all imports, parameter 3 is the path of the import data file

After the import is successful, you can reopen PL/SQL developer in the table column to see the data you just imported, it is very convenient.

The operation of the table is also very simple, open the SQL window directly using the SQL language can be arbitrary operation ~

Finish

How to connect an Oracle database with PL/SQL developer