Oracle12c Tutorial

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 »

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 columns like whether it is a Varchar ,integer or Float kind of an attribute. One needs to use the below …

Executing CREATE statements in SQL plus 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 »