What is Oracle?

Oracle is a DB for UNIX or Windows.

– Advantages of Oracle UNIX:

Significant performance improvement

Provides High Availability

Contains in-depth system utilities and open-source code

Highly respected by Oracle personnel

– Advantages of Oracle Windows:

Very easy to deploy and support

Requires far less IT training

Simple interface to Microsoft tools such as ODBC and .NET.

– Disadvantages of Oracle UNIX:

Required specialized skills (vi editor, shell scripting, etc.)

Required highly-technical Systems Administrators and DBA

Contains in-depth system utilities and open-source code

Security Holes (if mis-configured)

Susceptible to root kit attacks

– Disadvantages of Oracle Windows:

Slower than Linux

Less glamorous for the SA and DBA

History of poor reliability (bad reputation)

Security Holes (if mis-configured)

Susceptible to Internet viruses

Create a try database for free

1. Go to https://apex.oracle.com/en/

2. Click Get Started> Free Workspace> Application Development

3. Choose a ‘Workspace’ name, you will login using workspace / username / password combination

4. Choose your ‘Schema Name’, it is the Oracle database user.

5. Complete the registration and login

6. Click on SQL Workshop> SQL Commands

7. Notice on top right your ‘Schema Name’, Input the code:


CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255) NOT NULL,
Address varchar(255),
City varchar(255)
);

Notice the endline semicolon ;

Click ‘Run’> in the foot of the page you will have the system message ‘Table created’

8. Go Back, in the left columns you will see the table ‘PERSONS’ listed

9. Click on the top ‘Object Browser’> aftet that on the left column ‘PERSONS’, on the centen you will see the table content

Populate the database

1. Type the code:


INSERT INTO Persons 
(P_Id,LastName,FirstName,Address,City)
VALUES 
(1,'Rossi','Mario','Route 66','Los Angeles');

Notice to insert the strings you need double single apex as ‘stringName’

Let’s go on:


Go to Object Browser> PERSONS> Data

INSERT INTO Persons 
(P_Id,LastName,FirstName,Address,City)
VALUES 
(2,'Rossi','Luigi','Route 77','Los Angeles');

Then:


INSERT INTO Persons 
(P_Id,LastName,FirstName,Address,City)
VALUES 
(3,'Rossi','Andrea','Route 77','Los Angeles');

At the end we will have:

P_ID 1 | 2 | 3
LASTNAME Rossi | Rossi | Rossi
FIRSTNAME Mario | Luigi | Andrea
ADDRESS Route 66 | Route 77 | Route 77
CITY Los Angeles | Los Angeles | Los Angeles

References and docs:
https://apex.oracle.com/en/
http://www.w3schools.com/sql/default.asp
Ref: https://www.techonthenet.com/oracle/