• Home
  • Testing
  • SAP
  • Web
  • Must Learn!
  • Big Data
  • Live Projects
  • Blog

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.

 

YOU MIGHT LIKE: