banner oracle database actions

Loading database ‘HR’​ in Oracle Database Actions

This article takes a look at the Oracle Cloud solution “Oracle Database Actions”. An ADW database will be created thanks to Oracle Autonomous and in it, we will create an example database. For this, the well-known HR test database will be used.

Requirements

For this exercise you will need to have an Oracle Cloud account. Although, as in all cloud there are paid services, it also has some free ones. In this exercise, only free resources will be used so that you can continue without problems, although when opening the account you will be required to enter a credit card. But do not worry that you will not be charged anything, unless you use services that are not free of course.

Oracle Cloud

First, go to the Oracle Cloud site and proceed to enter with your credentials.

home

Once you have entered the Dashboard, you can view various services that you can use for free:

Attention! To avoid fees, choose options labeled "Always Free Eligible."

Autonomous Data Warehouse

The following window will open. We are going to build an ADW (Autonomous data warehouse) database.

autonomous

In the opened window, fill in the fields to create the database. You should already have a ‘compartment’ assigned, which is created when you open your account. Here you can choose the one that offers you.

In ‘Display name’ and ‘Database name’ you can give it any name or leave the one that appears by default.

You can leave the other default options as shown here to avoid charges.

info DB

Next, create a password to manage your database. The ADMIN user will not be able to edit it in this free plan.

The type of network and the license, you must leave it as indicated here:

credentials

Finally, enter a valid email and press the ‘Create Autonomous Database’ button.

info

The system will redirect you to a window like this, in which you must wait until the logo turns green and ‘available’, as shown in the image.

Once here, you can now go to the ‘Database Actions’ option.

Here you will find various options, among which is SQL. This will open the ultimate console for you to work with.

DB Actions

Access to sample data

To access the data that we will use as an example, in this case the Oracle human resources database, we must go to the following Oracle repository: github.com/oracle/db-sample-schemas/tree/main/human_resources

Once here and for this example, just download these two files:

hr_cre.sql

hr_popul.sql

These files contain the queries needed to create the tables and populate them with data.

Visualizing the data

data

When executing these statements, Oracle Database Actions already shows us the tables with their corresponding data.

Now you can start working with them.

Connect through SQL Developer

Create a new connection.

Now enter the following information:

A continuación se incluye la descripción de adb_connect_sqldev_db20.png

Name : Create a name for this connection.

Username: ADMIN (Only option for this free service.)

Password: Enter the password for the database user.

Connection type: select Cloud Wallet (with previous version, SQL Developer 18.2, it is Cloud PDB)

Configuration File : Click Browse and select the client credentials zip file.

This file can be downloaded from:

DB Connection -> Download wallet

credentials

Service: enter the name of the service. The client credentials file provides the service names.

Finally Test and Connect.

sql developer

source of the images: https://www.oracle.com/database/technologies/appdev/db-actions.html

Related Posts

Leave a Reply

Your email address will not be published.