can anyone elaborate the difference between SQL, MS SQL, MY SQL and PL/SQL?? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 6

can anyone elaborate the difference between SQL, MS SQL, MY SQL and PL/SQL??

4th Nov 2016, 4:49 AM
Madhur Munjal
Madhur Munjal - avatar
4 Answers
+ 26
SQL is the language name. MS SQL is the Microsoft database that implements the SQL language. MySQL was an open source database, also implementing SQL, but it was acquired by Sun, later acquired itself by Oracle. PL SQL is a procedural extension to SQL (e. g. you can use it to write programs with vars/loops/if etc.). It is implemented by the Oracle database and a few others.
4th Nov 2016, 6:07 AM
Udi Finkelstein
Udi Finkelstein - avatar
+ 16
SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL is regularly used by database administrators, as well as by developers writing data integration scripts and data analysts looking to set up and run analytical queries.
10th Nov 2016, 5:24 AM
Mustafa Asaad
Mustafa Asaad - avatar
+ 6
SQL is a query language to operate on sets. It is more or less standardized, and used by almost all relational database management systems: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, etc. PL/SQL is a proprietary procedural language used by Oracle PL/pgSQL is a procedural language used by PostgreSQL TSQL is a proprietary procedural language used by Microsoft in SQL Server. Procedural languages are designed to extend SQL's abilities while being able to integrate well with SQL. Several features such as local variables and string/data processing are added. These features make the language Turing-complete. They are also used to write stored procedures: pieces of code residing on the server to manage complex business rules that are hard or impossible to manage with pure set-based operations.
7th Nov 2016, 3:13 PM
Raghunath S
Raghunath S - avatar
ms SQL is a database of Microsoft and my SQL as well as but SQL stand for structure query language whose we run SQL statement on database and pl stand for procedure language is the concept of queries in database
6th Nov 2016, 9:50 AM
Rajesh Rawat
Rajesh Rawat - avatar