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.

Oracle

Oracle:

It is an RDBMS from oracle corporation.
Any RDBMS is used to store and process Business Data.

Database Concept:

------------------------------
1. Data : Collection of Information of one entity is known an Data
ex: any one employee data, any one product data etc

2. Database: collection of Information of all objects with in the business, technically a database is a software to automate business activities.

3. DBMS(database management system): a database, which is providing management system services like:
A. Entity new data or inserting new data.
B. Updating data
C. Deleting unwanted data
D. Authentication or authenticating user
E. Providing security

4. RDBMS(relational database management System): It is a collection of inter-related data of all inter related objects within the business.
Note:
A. generally data is generated from each business object & business transaction.
B. as a database developer, we need to develop database application program(Stored procedures, functions, packages & triggers). each database application program is responsible for at least one business activity.