Oracle12c Tutorial

Downloading Oracle 12C from web

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

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. This user is called Oracle. Moreover there are 2 OS groups. oinstall This is basically the user’s primary group. The …

Oracle environments for Linux /Unix and Window users 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 the Oracle connect to. Some of the environment variables are as follows:- ORACLE_BASE This is the top most directory where …

Setting of environment variables during Oracle installation. 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 schema objects. Data Definition Language (DDL) These statements are used to create ,insert or alter structures in the existing and the …

SQL calling environments. 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 is specified along with the values to be inserted in the table. Here in the table Students the values inserted …

Executing INSERT statements in SQL plus Executing queries using SQL plus on Oracle database Read More »

Executing queries using UPDATE statements

Executing queries using UPDATE statements The update query is used to update certain records in the table based on a certain condition or expression. We can execute the update statement as in Fig 7.8 Fig 7.8 The above figure executes the update query on the table students where a certain city is updated based on …

Executing queries using UPDATE statements Read More »

Executing queries using DELETE statements

Executing queries using DELETE statements The delete statement is used to delete certain records from the table based on a certain condition or expression. Fig 7.10 shows how to execute the delete statement. Fig 7.10 The fig 7.11 shows how this delete command is executed and the results are shown. Fig 7.11 The above figure …

Executing queries using DELETE statements Read More »

Indexing in Oracle 12C

Indexing in Oracle 12C is generally creating an index on a partitioned table, one or more set of columns. The prerequisites for creating an index are:- » One should have a Create index privilege » The indexing needs to be done one the schema owned. » The privilege of the creating index on object should …

Indexing in Oracle 12C Read More »

Scroll to Top