Called Structure Query Language or Sequel Query Language.
First developed by Andrew Richardson, Donald C. Messerly and Raymond F. Boyce Of IBM in the 1970.
SQL has been an official standard, promulgated by the International Institute of Standardization (ISO) and its American Affiliate, the American National Standard Institute (ANSI) since 1986.
There were lot of version of SQL introduced like SQL86, SQL89, SQL92 and SQL99.
Following are standard sub-components of SQL99.
SQL Framework
Provides logical concept
SQL Foundation
Builds on the material in Framework and specifies, for the more fundamental parts of the standard,the actual nuts and bolts of the language.
SQL/CLI (Call-level interface)
Specifies a standard API (Application Programming Interface) through which
SQL operations can be called.
SQL/PSM (Persistent Stored Modules)
Refers to procedural extensions to SQL that make it computationally complete and therefore suitable for the development of full applications.
SQL/Bindings
Specifies how SQL is to be bound to variable host languages,excluding Java.
SQL/MM (Multimedia)
This extends SQL to deal intelligently with large,complex and sometimes streaming items of data, such as video,audio and spatial data.
SQL/OLB (Object Languege Bindings)
Part 0 (as they call it) of the SQLJ specification for embedding SQL in Java.
In short SQL was developed by IBM in 1970. First commercial used by Oracle. And day by day all DBMS and RDBMS are following to use this language for Backend interaction.
Thanks and regards,
Gitesh Trivedi.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.