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

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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