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.