Oracle

Oracle

What is SQL?

Structured Query Language (SQL) is a domain-specific language used in programming and proposed for handling data in a relational database management system (RDBMS), or for stream execution in an RDSMS.

Formerly based upon relational algebra and tuple relational calculus, SQL involves of a data definition language (DDL), data manipulation language (DML), and data control language (DCL). The constraint of SQL includes data insert, query, update and delete, schema formation and alteration, and data access control. Though SQL is often labelled as, and to a great degree is, a declarative language (4GL), it also comprises procedural components.

SQL was one of the first profitable languages. In spite of not completely following the relational model as labelled by Codd, it developed the most extensively used database language.

SQL developed a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987. Since then, the standard has been studied to include a larger set of topographies. In spite of the presence of such standards, most SQL code is not portable among different database systems without alterations.