Oracle12c Tutorial

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

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 …

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 …

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 …

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. …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …