SQL is a domain specific language utilized as a part of programming and intended for overseeing information held in a social database administration framework (RDBMS), or for stream handling in a social information stream administration framework (RDSMS). It is especially helpful in dealing with organized information where there are relations between various substances/factors of the data. SQL was one of the primary business dialects for Edgar F. Codd’s social model, as portrayed in his powerful 1970 paper, “A Relational Model of Data for Large Shared Data Banks”. Despite not so much holding fast to the social model as depicted by Codd, it turned into the most broadly utilized database language.
SQL is intended for a particular reason: to inquiry information contained in a social database. SQL is a set-based, declarative programming language, not an imperative programming like C or BASIC. Be that as it may, augmentations to Standard SQL include procedural programming language usefulness, for example, control-of-flow builds. These include: SQL Procedural Extension
SQl Procedural Extension:
|Source||Common Name||Full Name|
|ANSI/ISO||Standard SQL/PSM||SQL/Persistent Stored Modules|
|IBM DB2||SQL PL||SQL Procedural Language (executes SQL/PSM)|
|International Business Machine(IBM) Informix||SPL||Stored Procedural Language|
|IBM Netezza||NZPLSQL||(based on Postgres PL/pgSQL)|
|Invantive||PSQL||Invantive Procedural SQL (executes SQL/PSM and PL/SQL)|
|Mimer||SQL||SQL/PSM SQL/Persistent Stored Module (executes SQL/PSM)|
|MySQL||SQL/PSM||SQL/Persistent Stored Module (executes SQL/PSM)|
|MonetDB||SQL/PSM||SQL/Persistent Stored Module (executes SQL/PSM)|
|NuoDB||SSP||Starkey Stored Procedures|
|Oracle||PL/SQL||Procedural Language/SQL (in view of Ada)|
|PostgreSQL||PL/pgSQL||Procedural Language/PostgreSQL Structured Query Language (executes SQL/PSM)|
|SAP R/3||ABAP||Advanced Business Application Programming|
|Sybase||Watcom-SQL||SQL Anywhere Watcom-SQL Dialect|
|Teradata||SPL||Stored Procedural Language|
This are the following SQL procedural extension , and many of us have used few among the list. Some famous SQL procedural extensions are: MySQL,Oracle,Microsoft/Sybase.
Hope that you like the article ; Drop your doubts and queries in the common section down below.