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:
Post a Comment