Oracle12c Tutorial

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 »

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 »