SQL is the standard language to query a database.

PL SQL basically stands for "Procedural Language extensions to SQL." This is the extension of Structured Query Language (SQL) that is used in Oracle.

T-SQL basically stands for " Transact-SQL." This is the extension of Structured Query Language (SQL) that is used in Microsoft.

In this tutorial, we will learn-

Difference between SQL and PL/SQL

SQL

PL/SQL
  • SQL is a single query that is used to perform DML and DDL operations.
  • PL/SQL is a block of codes that used to write the entire program blocks/ procedure/ function, etc.
  • It is declarative, that defines what need to be done, rather than how things need to be done.
  • PL/SQL is procedural that defines how the things needs to be done.
  • Execute as a single statement.
  • Execute as a whole block.
  • Mainly used to manipulate data.
  • Mainly used to create an application.
  • Interaction with a Database server.
  • No interaction with the database server.
  • Cannot contain PL/SQL code in it.
  • It is an extension of SQL, so that it can contain SQL inside it.

Difference Between T-SQL and PL-SQL

T-SQL
PL-SQL
  • T-SQL is a Microsoft product.
  • PL-SQL is developed by Oracle.
  • Full Form of TL SQL is Transact Structure Query language.
  • Full Form of PL SQL is Procedural Language Structural Query Language.
  • T-SQL gives a high degree of control to programmers.
  • It is a natural programming language that blends easily with the SQL
  • T-SQL performs best with Microsoft SQL server
  • PL-SQL performs best with Oracle database server.
  • It is easy and simple to understand.
  • PL-SQL is complex to understand.
  • T-SQL allows inserting multiples rows into a table using the BULK INSERT statement.
  • PL/SQL supports oops concepts like data encapsulation, function overloading, and information hiding.
  • SELECT INTO statement used in T-SQL
  • INSERT INTO statement must be used in PL/SQL
  • In T-SQL NOT EXISTS clause used along with SELECT statements.
  • In PL/SQL, there is a MINUS operator, which could be used with SELECT statements

Difference between SQL and T-SQL

SQL
T-SQL
  • SQL is a programming language which focuses on managing relational databases.
  • T-SQL is a procedural extension used by SQL Server.
  • This is used for controlling and manipulating data where large amounts of information are stored about products, clients, etc.
  • T-SQL has some features that are not available in SQL. Like procedural programming elements and a local variable to provide more flexible control of how the application flows.
  • SQL queries submitted individually to the database server.
  • T-SQL writes a program in such a way that all commands are submitted to the server in a single go
  • The syntax was formalized for many commands; some of these are SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
  • It also includes special functions like the converted date () and some other functions which are not part of the regular SQL.

 

Guru99 is Sponsored by AQUAFOLD
Aquafold

Aqua Data Studio is proud to sponsor Guru99's informative website for database professionals. Take your productivity to new heights with query tools, visual analytics, and ER diagramming for multiple platforms.