The difference between SQL, T and Pl-sql

SQL is the abbreviation for structrued Query Language, which is the Structured Query language. It is the standard that is responsible for the database interaction maintained with ANSI (American National Standards Institute). As the standard language of relational database, it has been adopted by many commercial DBMS products, making it become a mainstream language in relational database domain, including not only data query function, but also inserting, deleting, updating and data definition function.

T-SQL, which is Transact-SQL, is the enhanced version on Microsoft SQL Server, which is the primary language for applications to communicate with SQL Server. T-SQL provides the DDL and DML capabilities of standard SQL, plus extended functions, system stored procedures, and program design structures such as IF and while to make programming more resilient.

PL/SQL (procedural language/sql) is a procedural language that is a third-generation language that focuses on processing details like C, C + +, and Java, and can be used to implement more complex business logic. It allows SQL's data manipulation language and query statements to be included in the Block structure (block_structured) and the code process language, making PL/C a powerful transactional language. In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to federate database languages and procedural languages. The basic unit of PL/SQL is called a section consisting of three parts: a declaration part, a operational part, and an exclusion-build section. Because PL/SQL allows you to mix statements and process structures, you can use PL/SQL sections and sub-programs to combine the statements of your statements before sending them to the Oracle system, without PL/SQL, Oracle needs to deal with each and every time it claims, in a networked environment, which affects traffic flow, and increase the response time. The PL/SQL section is compiled only once and is stored in a running format to reduce response time. In a word, T-SQL and PL-SQL are in SQL Server and Oracle's respective upgraded SQL language

The difference between SQL, T and Pl-sql