WHAT IS SQL

ORACLE is a powerful rdbms product that provides efficient and effective solutions for major database.An oracle data base system can easily take advantage of distributed processing by using its client/server architecture.
                  ORACLE IS A COMBINATION OF SQL AND PL/SQL.
FIRST KNOWN SQL:
WHAT IS SQL:
           SQL stands for structured query language.SQL is used to communicate with a database.According to ANSI(american national standards institute),it is the standard language for relational database management syatems.SQL statements are used to perform tasks such as update data on a database.or retrieve data from database.some common relational database management systems that use SQL are:oracle,sybase,microsoft sql server,access,ingres,etc.
                                               it is non procedural language which is used to communicate with any type of database.this language was developed by german scientist mr E.F CODD AT 1968 in 1970 ANSI approved this language and 1972 sql was released in the market.
FEATURES OF SQL:

• it is a non-procedural language
• it can also pronounced as SEQUEL
• it is not a case sensitive language.
• it can be called as natural language interface because almost all sql commands similar to normal english language
• it is the common language to interact with any type of database such as oracle,db2 etc.

SUB LANGUAGES OF SQL:
          it was divided into following types.

• data defination language(DDL)
• data manipulation language(DML)
• data retrieval language(DRL)
• transaction control language(TCL)
• data control language(DCL)