- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between T-SQL and PL-SQL
In this post, we will understand the difference between T-SQL and PL-SQL.
T-SQL
It is a Microsoft product.
It is known as Transact Structure Query language.
It gives a high degree of control to the developers/programmers.
It works its best, and provides good performance with Microsoft SQL server.
It is easy.
It is simple to understand.
It allows the insertion of multiple rows into a table.
This is done with the help of the ‘BULK INSERT’ statement.
The ‘SELECT INTO’ statement is used in T-SQL
In this, the ‘NOT EXISTS’ clause can be used with the ‘SELECT’ statements.
PL-SQL
It is an Oracle product.
It is known as Procedural Language Structural Query Language.
It is a natural programming language.
It works easily with the SQL.
It works its best, and provides good performance with Oracle database server.
It is not easy.
It is complex to understand.
It supports object oriented programming concepts such as data encapsulation, function overloading, and information hiding.
The ‘INSERT INTO’ statement needs to be used in PL/SQL.
It has a ‘MINUS’ operator, that can be used the ‘SELECT’ statements.
- Related Questions & Answers
- Difference between SQL and PL/SQL
- Difference Between SQL and T-SQL
- Difference between SQL(Structured Query Language) and T-SQL(Transact-SQL).
- Difference between Static SQL and Dynamic SQL
- What is PL/SQL?
- Difference between SQL and NoSQL
- Difference between MySQL and SQL Server
- Difference between Oracle and SQL Server
- Difference between DELETE and DROP SQL
- Reverse a Number in PL/SQL
- Difference between Open SQL, Native SQL in SAP HANA
- Difference between Join and union in SQL
- Difference Between DELETE and DROP in SQL
- Difference Between COMMIT and ROLLBACK in SQL
- Database Wars: MSSQL Server, Oracle PL/SQL and MySQL