Oracle Database Installation in Windows and OracleSQLDeveloper (graphic description)

Oracle Database Installation in Windows and OracleSQLDeveloper (graphic description)

Problem: Install the Oracle database in windows

Step: Use the URL"Http://www.oracle.com" to open the Oracle official website home page, click Downloads to enter the Oracle database download page. :

Click to enter: select database

Select Oracle Database Express Edition 11g

Because my computer is 64-bit, you can download the first one.

Step 1: Double-click setup.exe to start the installation wizard.

First, extract the downloaded oracle Installation Package. Double-click to open the page as follows:

Click next:

Continue to the next step. Enter the password to customize it.

Next, click "Install:

Wait a long time. Installation completed:

In this case, the Oracle icon appears on the desktop.

To facilitate the use of Oracle databases, I installed Oracle SQL Developer to access Oracle

Oracle SQL Developer is a free graphical development tool officially produced by Oracle. Compared with SQL * Plus, the graphical interface is easy to operate, without having to remember a large number of commands, and the output results are beautiful. Its basic functions include formatting and output of results, automatic editor prompts, code beautification, display of SQL Execution plans, monitoring conversations, writing and debugging stored procedures. Official and free features make this tool very attractive.

Steps:

Go to the Oracle SQL Developer download page at the following URL;

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Download Page:

 

Step 2: Download,

Decompress the package. The obtained file contains a “sqlcmd.exe ". Double-click it to go to the main interface of the SQL tool. It will first let you select the directory file of JDK. It will be in later.

Next is the interface:

When you enter SQL Developer for the first time, you need to set the connection parameters. Right-click connection on the left side of the window to start a new connection.