Oracle 11g XE ,Installation steps & running code database

Written by : AMAN Sharma

1.1 Installation steps:
Step#1: Go to this link to download:
https://www.oracle.com/database/technologies/xe-downloads.html

Click Download and wait for download.
➢ After downloading the Oracle Database XE installation executable,
setup.exe, double-click it.
➢ Then Extract files.

Step#4: Now click I accept the terms in the license agreement.

Accept the terms. And click Next again until you have to enter
password.

Finally Click Finish.

Set connection to start Oracle.
Step#1: Type connect and press enter.
Step#2: Enter system press enter.
Step#3: Enter the same password used while installing and press install.
Now, it’s connected.

1.2 Data Definition Language (DDL):
DDL is used to specify a database scheme as a set of definitions
expressed on a DDL. DDL statements are compiled, resulting in a set
of tables stored in a special file called a data dictionary. The data
dictionary contains metadata (data about data). Data Definition
Language, which deals with database schemas and descriptions, of
how the data should reside in the database.
The Data Definition Language (DDL) includes;

• CREATE: to create a database and its objects like (table,
index, views, store procedure, function, and triggers)

1.3 Data Manipulation Language (DML):
`A DML is a language which enables users to access and
manipulate data. The goal is to provide efficient human interaction
with the system. It is used to store, modify, retrieve, delete and update
data in a database.
The Data Manipulation Language (DML) includes:

• INSERT: Insert the data from a database.

1.4 Data Control Language (DCL):
➢ Data Control Language (DCL) deals with the commands used
in SQL that permit a user to access, modify or work on the
different privileges in order to control the database.

The Types of Data Control Language (DCL) are as follows:
• Grant
• Revoke

Grant:
It is used to give user access privileges to a database.
Example:
GRANT SELECT, UPDATE ON MY_TABLE TO SOME_USER, A
NOTHER_USER;
CREATE SESSION, CREATE TABLE, UNLIMITED
TABLESPACE
• CREATE SESSION

Revoke:
It is used to take back permissions from the user.

Example:
REVOKE SELECT, UPDATE ON MY_TABLE FROM USE1,
USER2;

• JOIN: Combines data from multiple tables based on related columns.

5 thoughts on “Oracle 11g XE ,Installation steps & running code database

Leave a Reply

Your email address will not be published. Required fields are marked *