Downloading Oracle 12c
Install and download Oracle 12c for learning Oracle database developer. It also supports PL/SQL.Downloading Oracle SQL Developer
We
need to download Oracle 12c database
from oracle website this is the latest version of oracle currently
You
can follow the given link to download that
Check
on the Accept License Agreement and Click on the winx64_12201_database.zip file, Signup with oracle to download and install
the file
You
need to unlock the HR account to access the tables in HR Schema. Schema
contains list of tables, we do our practical on HR schema.
One
of the Schema in Oracle SQL Developer is HR Schema. It contains many tables
such as employees, departments, locations, etc. We need to unlock the HR schema
because it is present in pluggable database. Let’s see what pluggable database
means
Oracle
12c have Container Databases and Pluggable databases.
One
Container Database have many pluggable databases. Pluggable database have many
schemas. Schemas consists of many tables.
In
fig 2.1 you can see one Container Database (CDB), many pluggable Databases
(PDBs) present in container databases.
Our
HR schema is present in one of the Pluggable database. So we need to enter into
the Container Database (CDB) and then to Pluggable database just like changing
the directories (From root Directory to Sub-directories)
0 comments:
Post a Comment