Types Of Indexes In Oracle

• Index is an Object in Oracle. 
• It is a Performance Optimization Technique
• It speed up or increase the performance of the Query Execution.
• Index is creating automatically on Primary key and Unique Key.
• No need to create index for primary and unique keys columns.

Determining The Leap Year In Oracle

Finding the Leap Year in Oracle or how to find leap year in oracle SQL

open sql*plus login user name with your respected password after that .

find the sysdate from Dual. It gives the respected First day of the Month. As Shown below when you use Number Function that is Trunc. If you use the To_Char function then it gives the same day of the month when you executed the query.

DDL Commands in Oracle SQL With Examples

• DDL stands for Data Definition Languages .
• DDL Commands Used for create and modify the structure of the Objects ,Views, Sequences,Indexes, Schemas etc.
• Data Definition Languages is one of the Sub Language. 
• the commands of the DDL Language is 

SQL Aggregate Functions

Aggregate Functions summarizes the Result of an over a number of Rows in a table and give the result like one row. Actually Aggregate Function mostly used in Group by Function ,it means sum of salary, min of salary,max of salary,count of students,average of salary from each department.

SQL Clauses

SQL Sub Queries

SQL Joins

Top Searching Topics
Types of indexes in oracle with example.

SQL Constrains

Top Searching Topics


types of index in oracle 10g with example

Oracle Datatypes

Top Searching Topics

Different types of indexes in oracle and How index works in oracle

Oracle Sub Languages Or SQL Commands

SQL Tutorial

SQL Stands for "Structure Query Language" and Standard Relational Data Base Language. The SQL supports the all Database products like Oracle SQL,SQL Server, My SQL, DB2, Teradata etc .This tutorial teaches the How to write the queries,Trobleshoot and Optimize the SQL.

" Concat the column with Spaces between two columns in oracle plsql and oracle sql"

Below is the code in Step By Step process to get the result as you think like
"Spaces between the columns when you concat the two columns from table in oracle sal"
As per Your Requirement There is a 9 Steps to get Like below Result.