Step by Step Tutorial On how to Setup Oracle Database to learn PL-SQL.

Database Designs

As we all know that Oracle is one of the most used corporate DBMS software. Oracle has been working on the PL/SQL extension to facilitate an make the Oracle Database more powerful and great for complex Queries. But, to learn or Used PL/SQL you need to have Oracle Database installed on your system. In this tutorial, I will guide you through the process of installing Oracle Database on your system.

 

What is PL/SQL?

PL/SQL is a Procedural Language (PL) that extends the Structured Query Language (SQL). If you have been programming Pascal or Ada, you will find much familiar syntax in PL/SQL.

It is difficult to write applications using SQL only because each SQL statement runs independently and has little or no effect on each other. To overcome this limitation, you often have to use other programming languages such as C/C++, NodeJS, PHP, and Java, by using standard database interfaces. Oracle supports this approach when you want to develop applications that interact with Oracle databases.

 

Download and Install Oracle Database.

1- you need to go to the Oracle official website and download the Oracle Database. We are going to download Oracle Database 11g Release 2 on Microsoft Windows (32bits).

2- unzip the downloaded files into a folder e.g., C:\setup\Oracle as follows:

B693a18b9fb58534_Oracle Installation Folder

3- double click the setup.exe file to start installing the Oracle database. You need to follow the steps as described in the following section:

 

Step 1.

In this step, you can provide your email to get updated information on security issues from Oracle.

861eb16ae1ae87dd_bproo Install Oracle Step 1

 

Step 2.

There are three options in this step as shown in the screenshot. Choose the first one to create and configure the database and click the Next button.

5ab7e7bb81b1d915_bproo Install Oracle Step 2

 

Step 3.

If you are installing an Oracle database in your laptop or desktop, choose the first option, otherwise, choose the second one and click the Next button.

93f908dd60819703_bproo Install Oracle Step 3

 

Step 4.

This step allows you to enter full database installation folders. You can change the Oracle base folder to e.g. c:\app\bproo, other folders be changed accordingly. After that click the Next button to go to the next step.

02f18685670347f8_bproo Install Oracle Step 41

 

Step 5.

In this step, Oracle will perform prerequisite checks before installing the Oracle database component.

6be0c476f0cf67d6_bproo Install Oracle Step 5

 

Step 6.

This step shows you summary information of the previous steps. Click the Finish button to start installing the Oracle database.

8ed805bee82c2c36_bproo Install Oracle Step 6

 

Step 7.

This step copies the files to the corresponding folder and installs the Oracle components and services. It takes a few minutes to finish so please be patient.

4fd44fce72058b46_bproo Install Oracle Step 7

 

After complete, the installer displays a database Configuration Assistant dialog, click on the Password Management… button to set up the passwords for different users.

We need to unlock the SYS, SYSTEM and HR users and set their corresponding passwords.

1st-step

Ce7a6d185b0858c8_bproo Install Oracle Step 7 DB Config Assistant

2nd-step

5626ae294638c052_bproo Install Oracle Step 7 DB Config Assistant SYS Users

3rd-step

3ace4bf9f61ae112_bproo Install Oracle Step 7 DB Config Assistant HR User

 

Step 8.

Once the installation process is done, you can click the button to close the installer.

37eb033be43dabba_bproo Install Oracle Step 8

 

Verify the installation

If everything is fine, you will see the Oracle folder as follows:

8dbfee9d0dcd451e_bproo Oracle Folder1

 

1- launch the SQL Plus that is a command-line interface tool that you can use to interact with Oracle databases.

2- enter the username and password that you have set in the installation process. we enter the HR user and its corresponding password.

519de33ec1aa479e_bproo SQL Plus Terminal

 

3- enter the following statement:

SELECT * FROM dual;

 

If you see the output as shown in the following screenshot, it means you have installed the Oracle database successfully and ready to start learning PL/SQL programming.

216132319c6a37d2_bproo Install Oracle Select Dual Table

 

I hope you got it up and running from the first reading. if that is not the case, please go through it again and make sure that you didn't make any mistake. and is you encounter a strange error hit the comment section and let us see if we can help.

 

You can share this post!

bproo user profil

Kamdjou Duplex

the world would not be so beautiful without people willing to share knowledge