- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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 Articles
- 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
- Reverse a Number in PL/SQL
- Difference between MySQL and SQL Server
- Difference between Oracle and SQL Server
- Difference between DELETE and DROP SQL
- Difference between Open SQL, Native SQL in SAP HANA
- Database Wars: MSSQL Server, Oracle PL/SQL and MySQL
- Block of PL/SQL in Oracle DBMS
- Program for Fibonacci numbers in PL/SQL
- Print pyramid of tutorialspoint in PL/SQL
