Step 1: Open the browser and search Oracle 12C for download. Fig 4.1 Step 2: Download the two files as seen on the web. Fig 4.2 Step 3: The two downloaded setups can be seen. Fig 4.3
Read More »Oracle12c Tutorial
Installing the setup for Oracle 12C
Step1: As soon as we double click on the set up a pop up comes up . Click Yes in the User Account Control window to continue with the installation. Fig 4.8 Step 2: The Configure Security …
Read More »Verifying the installation of Oracle 12C
Step1: As soon as we double click on the set up a pop up comes up . Click Yes in the User Account Control window to continue with the installation. Fig 4.8 Step 2: The Configure Security …
Read More »Verifying the installation of Oracle 12C
In this one has to verify the installation of Oracle 12C by means of certain files and performing certain steps as follows:- Verifying the Oracle services In this we need to navigate to C:\Windows\system32 and …
Read More »Oracle environments for Linux /Unix and Window users
There are some differences which exist between the Oracle installation for UNIX/LINUX and the Windows environment. These are as follows:- LINUX/UNIX In this environment one typically creates his own user to own the installation files. …
Read More »Setting of environment variables during Oracle installation.
The environment variables play a very important role to determine certain important things like:- • OS where the software has to run • Where will the Oracle will store the files. • Which database will …
Read More »Methods of creating Oracle databases.
One can create a database using various methods out of which 4 are listed as below:- Manually using SQL commands It is recommended that if one is working on a previous release like Oracle 8i …
Read More »Creation of Oracle database using the DBCAO.
One can easily create a database using a DBCA as it provides the following advantages:- It provides the necessary templates for defining and configuring a database which the other methods might not provide. Customization can …
Read More »Controlling database post creation in Oracle 12C
Controlling database post creation in Oracle 12C It is extremely necessary to do a post checkup after the database has been created. There are 3 things which need to be done:- Checking the initialization parameters …
Read More »SQL calling environments.
SQL calling environments. The first step to learn and execute the SQL command is to understand the following commands in SQL:- Data Manipulation Language (DML) These statements are used to manage the data within the various …
Read More »SQL plus as an interface to Oracle.
SQL plus is an interactive query tool which comes in collaboration and installed with Oracle 12C database. It is a client and acts as a interface to access the Oracle database. The advantages of using …
Read More »Beginning of SQL plus with Oracle1 2C
Some of the starting SQL commands are:- Some of the starting SQL commands are:- 1)Startup This command is used to restart /reboot the database or instance. This is necessary to start the database. Please refer to …
Read More »Executing CREATE statements in SQL plus
Executing CREATE statements in SQL plus We can execute the create table in an Oracle database in which we have to specify the columns that need to be created along with the datatypes for various …
Read More »Executing INSERT statements in SQL plus Executing queries using SQL plus on Oracle database
Executing INSERT statements in SQL plus The insert statement is used to insert data in the Oracle database through the SQL INSERT command. Fig 7.2 The above figure shows the INSERT command being executed where the table …
Read More »Executing the select queries in SQL plus
The select queries is used to fetch the data from the database .We can also use FROM to fetch the data from the table based on certain selection or condition. The below figure shows how …
Read More »