1. Transact SQL (T-SQL) :
T-SQL is an abbreviation for Transact Structure Query Language. It is a product by Microsoft and is an extension of SQL Language which is used to interact with relational databases. It is considered to perform best with Microsoft SQL servers. T-SQL statements are used to perform the transactions to the databases. T-SQL has huge importance since all the communications with an instance of SQL server are done by sending Transact-SQL statements to the server. Users can also define functions using T-SQL.
Types of T-SQL functions are :
- Aggregate functions.
- Ranking functions. There are different types of ranking functions.
- Rowset function.
- Scalar functions.
These additions bring T-SQL within the criteria of the Turing completeness test. Thus Transact-SQL is a programming language.
2. Procedural Language for SQL (PL/SQL) :
PL/SQL stands for Procedural Language for SQL. It is a procedural extension for SQL by Oracle Corporation also for the Oracle relational database. It’s major advantage is that it allows use of procedures, procedures are similar to functions. The main highlights of PL/SQL are that it gives us the functionality of iteration, decision making and many more features. The smallest functional unit in PL/SQL is called a block. It can handle exceptions (run-time errors).
PL/SQL is an application language, which is usually used to build, format and display the user screens, web pages and reports, while SQL provides data for these applications.
Difference between T-SQL and PL-SQL :
|1.||The full Form of TL-SQL is Transact Structure Query language.||The full Form of PL/SQL is Procedural Language Structural Query Language.|
|2.||T-SQL was developed by Microsoft.||PL-SQL is developed by Oracle.|
|3.||T-SQL provides a higher degree of control to the programmers.||It is a natural programming language that is much compatible with the SQL and provides higher functionality.|
|4.||T-SQL performs best with Microsoft SQL server.||PL-SQL performs best with Oracle database server.|
|5.||With help of BULK INSERT statement in T-SQL users can input multiple rows.||OOPS concepts like function overloading, information hiding and data encapsulation are supported by using PL/SQL.|
|6.||It is much easier to understand and simple to use.||It is considered more complex than T-SQL and more powerful.|
|7.||In T-SQL SELECT INTO statement must be used.||In PL/SQL INSERT INTO statement is to be be used.|
|8.||In T-SQL, both the DELETE and UPDATE statements are improved to enable data from another table to be used in the operations, without using a subquery.||In PL/SQL, subquery is needed to use data from another table in the operation.||9.||In T-SQL there is no AUTOCOMMIT command and transactions are saved by using COMMIT command manually after every transaction.||In PL/SQL AUTOCOMMIT can be used to automatically commit/save a transaction.|
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Difference between SQL and PLSQL
- Difference between AIX and iOS
- Difference between GCC and G++
- Difference between Hue and Pig
- Difference between H.323 and SIP
- Difference between RPC and RMI
- Difference Between DAS and SAN
- Difference between ADO and ADO.NET
- Difference between MAN and WAN
- Difference between PIP and HLP
- Difference Between GIT and SVN
- Difference between DDL and TCL
- What is the difference between GUI and CUI?
- Difference between DDR 5 and DDR 3
- Difference between H.323 and SIP
- Difference between CD-R and CD-RW
- What is the difference between MEAN.js and MEAN.io?
- Difference between ANN, CNN and RNN
- Difference between AIX and OS/2
- Difference between DFD and ERD
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.