Wednesday, October 15, 2014

INTRODUCTION TO ORACLE AND SOFTWARE DEVELOPMENT TOOLS OF ORACLE



Way back in June 1970, Dr E. F. Codd published a paper entitled A Relational Model of Data for Large Data Banks. This relational model, sponsored by IBM, then came to be accepted as the definitive model for RDBMS. The language developed by IBM to manipulate the data stored within Codd's model was originally called Structured English Query Language (SEQUEL) with the word English later being dropped in Favor Structured Query Language (SQL).
IN 1979 a company called Relational Software, Inc. released the first commercially available implementation of SQL. Relational Software later came to be known as Oracle Corporation. Oracle Corporation is a company at produces a most widely used Server based, Multi user RDBMS named Oracle.
SOFTWARE DEVELOPMENT TOOLS OF ORACLE

1.         Structured Query language. (SQL): It has 9 commands, which are common to all RDBMS
CREATE, DROP, ALTER for Tables
INSERT, UPDATE, DELETE for Records
GRANT, REVOKE for Permission
SELECT for Query

2.         SQL*PLUS: It is an extension to SQL. It has been introduced to eliminate SQL limitations. It has hundreds of SQL commands. SQL is a subset of SQL*PLUS. , It is used for setting up the environment.

3.         Procedural Language SQL (PL*SQL): It is a programming language native to Oracle. It supports OOPS. It's a Forth generation language (4GL).

4.         EXP: This is used to take Oracle database backups

5.         IMP: This is used to restore backups

6.         SQL * Loader: Converts files from other RDBMS To Oracle

7.         Personal Oracle: Single user version of the Oracle database engine (DOS + Windows)

No comments: