Oracle 11g R2 (Release 2) (64 bit)
Window 7 (64 bit)
- SQL Tutorial for Beginners with Oracle
Oracle to download this software.
32bit bit or
64bit to download exactly.
Oracle a bit:
The structure of
- Oracle software
- And Database
SCHEMA, and the name of
Schema is simultaneously the User name to log in that
Schema. A Schema contains a system of tables, views, functions, procedures, packages, etc.
That means that after installing the
Oracle software is complete, we can create one or more Database. Usually you only need 1.
Oracle software, and create two database named
ORCL respectively. The name of the database is also known as SID.
and begin installing the setup file in the folder 1. During the
installment, it will require you to indicate the position of folder 2
for continuing to install.
Oracle software and immediately create a Database named as
SID = db11g).
- Desktop class
- Character Set: Unicode (AL32UTF8)
- Global database name: db11g (You can select another name, this is the name of database, known as SID)
Oracle is successful. Parameters relating to database will be synthesized, and you should remember this information.
Windows shows a warning of blocking the activity of
Oracle, you click on
“Allow access” for allowing
Oracle to work.
Oracle, but usually three services are enough for the operation:
Service helps you access to the administration page to manage
Database through URL:
OracleDBConsole allows you to see overall how your DB
is operating, how resources are used, how users work, and what order is
executed,… (In this document, I do not mention it in detail).
Oracle is used for the purpose of learning, you can turn off the
OracleDBConsole service for avoiding wasting computer
resources unnecessarily. For the best, you turn the starting mode to
Manual so that the service does not automatically start whenever the
computer starts. You can actively run it if necessary.
SQL Plus is a simple Console tool that allows you to
execute SQL command. Usually, we work with a more visual tool (It is
unavailable when you install
Oracle) that you need to install additionally. It can be software provided by a third party.
To have the highest permissions we log into user
To login user
sys with the highest privileges (sysdba: System DB Admin)
- sys/admin@db11g as sysdba
Here I access the
system (user) to create an example schema (Not necessarily use DBA privileges)
Create a new
SCHEMA whose name is myschema and password is 1234. In essence, we create a
user whose name is
schema are the same name in
-- Create user (schema), password 1234
-- Grant to myschema.
-- For example: dba: DB Admin.
Connect to the Schema just created:
Try to query a table:
Note: DUAL is a system table, can use in all SCHEMA, can try query it.
-- DUAL is a system table.
-- Create table Account
Account (User_Name varchar2(30), Full_Name varchar2(64) ) ;
-- Insert 2 row to Account.
You should install a visual tool,
SQL Plus is just a basic tool.
You can see the instruction of installing and using a visual tool (
- Installing and configuring PL/SQL Developer
As we all know, Oracle can create multiple databases.
Each database has a name, the name is usually the same as the SID (System Identify DB).
Database have one or more Schema
We rarely have to add a new
Database, if any, we add a new
Schema to an available
Database. However, during the installation of
Oracle, if you don’t select to automatically create Database, you can use this function to create a new DB. Besides, if you install
Database whose Character Set is unsuitable, you can delete DB and create a new one.
In case you want to delete available Database:
Crate a Database:
Enter Database name and
SID. For the best,
SID should be alike Database name.
The installation is simple, you can continue.