Diagram of ways to connect Oracle databases using PL/SQL developer _oracle

Because of the reasons for the project need to use the Oracle database, due to time constraints can not learn from the foundation, and the Oracle operation of the command interface is too unfriendly, so I found Pl/sql developer this very useful software to indirectly use the database.

Here's a brief description of how to use this software to connect to Oracle databases.

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 to pay attention to 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 will have a hint, the best point open Order management, you can see a lot of information related to the account, the best screenshot to save, especially to remember the system account information.

Pl/sql installation is simpler, there are many resources on the Internet can be directly used after decompression, if there are problems can be 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.

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

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

Create user hahaha identified by 123456;

When entered, the user is shown to have created, and the following code is used to grant permissions:

Grant CONNECT,RESOURCE,DBA to hahaha;

After the completion of the figure:

Step three connect Oracle database with Pl/sql developer

Open the Pl/sql client and enter the following information

Account number and password is your newly created account password, the database is the name that you give to the general databases when installing, click OK can connect.

If the connection is not likely to be a problem with the connection Agreement, you need to modify the corresponding parameters in the configuration, this can be your own Baidu.

This problem does not occur if Oracle has not been installed before and is implemented step-by-step with my steps.

Attached: File Import method

Open cmd

First enter your data in the Bin folder (because the computer and installation mode, the path is different, 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 to the database using the IMP command, for example:

Imp userid=hahaha/123456@orcl123 full=y file=e:\data\his_20131124dmp.dmp

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

After showing that the import was successful, you can reopen Pl/sql developer the column in the table to see the data just imported, very convenient.

The operation of the table is also very simple, directly open the SQL window to use the SQL language can be free to operate the ~

The above is a small set for you to introduce the use of Pl/sql developer to connect Oracle database method diagram, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!