SQL Commands: ORACLE

SQL Commands:

1. DDL Commands (data definition language)
A. CREATE
B. TRUNCATE
C. ALTER
D. RENAME
E. DROP

2. DML Commands (Data Manipulation language)
A. INSERT
B. UPDATE
C. DELETE

3. DCL Commands (Data control language)
A. GRANT
B. REVOKE

4. TCL commands (Transaction control language)
A. COMMIT
B. ROLLABCK
C. SAVEPOINT

5. DRL command (Data Retrieval language)
A. SELECT

Note: all commands except select are physical command means they effect database,
select is a logical command and it not affect database.

Oracle version

Version of Oracle:

In 1986, oracle Corp released its first commercial database i.e. oracle 7
Oracle-7: It is a stand alone RDBMS, it is not supporting online processing.

Oracle-8: It is stand alone RDBMS and it having indexes.
Note: these 2 database are unable to process business data in online process.

Oracle-8i: it is supporting internet application like webpages(html & java) supports online data processing.
   i stands for internet application from this version oracle supporting online data processing.

Oracle-9i: It also supporting Internet application
   it Support online data processing.
   It supports e-buz development tools(ERP-Enterprises resources planet)

Oracle-10g: (grid technology)
   a grid is nothing but a mesh like architecture.
   each consecutive point in the mesh, is considered as server.
   each server connected with atleast one server within the grid.
-  g for grid technology, within database grid, any server is easily communicating with any other server. i.i. supporting centralized
data processing.

Oracle-11g: It is having in built data warehouse builder.
    It is having OLTP development tools & OLAP development tools-(Oracle Warehouse Builder)

Oracle-12c: Cloud Computing
    It provides a facility to connect with any technology cloud without installing technology in the personal system.