• History Of Oracle: 

Oracle is most widely used Database Management System in most of the Companies.Oracle uses SQL   pronounced as ‘Sequel’ language to data manipulation and operations on data.I am explaining History of Oracle in this article. ‘SEQUEL’ stands for ‘Structured English Query Language’ which is developed by IBM Corporation limited to use codd’s model in 1979.In 1979 Oracle introduced first commercially available implementation of SQL.Now SQL is called as Standard RDBMS language.Oracle Corporation was started by two computer programmers, Larry Ellison and Bob Miner in 1977. Both Larry and Bob had prior experience in building database programs for different companies. Their first project was building a special database program for the CIA (Central Intelligence Agency).

History of Oracle
History of Oracle


Larry Erison is the father of Oracle who has started the company named Software Development Laboratory in 1977.Now This Company is known as ‘Oracle Corporation’

  • Different Versions Of Oracle:
  • In 1977, SEL (Software Development Laboratory) … V1
  • In 1979, RSI (Relational S/W Incorporation) …. V2
  • In 1983, Oracle Corporation à Oracle 3 [Developed Using ‘C’, which supports simple queries but does not support transactions]
  • In 1984, Oracle 4 à Supports Transactions [Commit/Rollback]
  • In 1985, Oracle 5 à Client-Server Architecture [Only install DB in Server, so that ‘N’ no of Clients can connect is known as Client-Server Architecture].
  • In 1989, Oracle 6 à PL/SQL
  • In 1992, Oracle 7 à Supports DWH [OLAP-Online Analytical Processing]
  • In 1997, Oracle 8 à ORDMBS
  • In 1999, Oracle 8i à ‘I’ means Internet & it has inbuilt JVM (JAVA Virtual Machine)
  • In 2001, Oracle 9i à with 400 New features, e.g. XML (Xtended Markup Language), RAC (Real Application Clusters) etc which provided high availability & performance.
  • In 2003, Oracle 10g à ‘g’ means grid (group of DB Servers)
  • In 2006, Oracle 11g àwe can add columns with values etc.

Oracle SQL lanuagage is very easy to understand and user friendly language.If you understands english you will easily understand SQL Language.You will do anything with a data using oracle SQL language.

“So now dont Waste your time and let us start learning Oracle SQL..”

SQL Tutorials and Topics:

  1. SQL Create Table
  2. SQL Select Statement Execution
  3. Views in SQL
  4. Materialized View in SQL
  5. Joins in SQL
  6. Inner Join / Outer Join
  7. Full Outer Join / Cartesian Join
  8. Union and Union ALL
  9. Intersect and Minus
  10. Indexing in SQL
  11. Rank and Dense Rank
  12. SubQueries and Correlated Subqueries
  13. Parser and Optimizer
  14. Oracle 11 G new Features

10 Trackbacks / Pingbacks

  1. Interview Questions For Oracle | SQL interview Questions
  2. Database Normalization Examples | Normalization in Database with Examples | Database Normalization with Real Life Examples | Designing Normalized Database
  3. Oracle Partitioning | Table Partitioning in Oracle | Partitioning in SQL | How Partitioning helps improving Performance | Table Partitioning with Examples | Partitioning on existing table
  4. Operators in SQL | SQL Operators | Arithmetic Operators | Logical Operators | Comparison Operators | Negation Operators | Operators in SQL with Examples
  5. Pivot in SQL with Example | Pivot Clause | Pivot and unpivot in SQL | Pivot in Oracle | SQL Pivot with Real Life Example
  6. Difference between Truncate and Delete, Drop in SQL | Truncate Delete and Drop Commands in SQL | SQL Difference between Truncate,Delete and Drop Commands | Real Life Examples of Truncate Delete and Drop Command
  7. Process Commands in Unix | Unix Filter commands | Touch command with example | ps command with examples | Kill command with examples
  8. Unix Directory Commands | Create Directory in Unix | Mkdir Command with Example | PWD command with example | Rmdir command to remove directory | Cd command to change directory
  9. SQL Constraints | Constraints in SQL | Primary Key in SQL | Foreign Key in SQL | Check Constraints in SQL | Null Value
  10. OBIEE

Comments are closed.