Oracle

  • 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 (X tended 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.
  • In July 2014 Oracle 12 C is launched which means oracle with Cloud.
  • In Feb 2018 Oracle 18 C is launched which is worlds first autonomous database

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..”

  • Why SQL?
    • Allows users to access data in relational database management systems.
    • Allows users to define the data in database and manipulate that data.
    • Allows users to create and drop databases and tables.
    • Allows users to create view, stored procedure, functions in a database.
    • Allows users to set permissions on tables, procedures, and views.

What You will Find Related to Oracle in Website?

You will find lot of new concepts related to Oracle in this website.The Oracle 18c is launched recently in Feb 2018.User will get idea about oracle 18c with its features and advantages. It has some impact on DBA’s also.I have added the Article of Oracle 18c Impact on DBAs.

Following are some Bullet points regarding Oracle :

CLICK TO LEARN SQL TUTORIALS

CLICK TO LEARN ORACLE ERRORS

CLICK TO LEARN ORACLE 18 C

 

 

 

 

 

 

User will find the Quality content regarding Oracle with different kind of interview questions with its answers.Our vision is to make audience SQL friendly and the user of this website will learn SQL and Oracle like Technologies with Ease.

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.