Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

What is the difference between SQL, PL-SQL, and T-SQL?

Can anyone explain what the differences between these three are, and provide scenarios where each would be relevantly used?

1 Answer

0 votes
by (40.7k points)

Differences between SQL, T-SQL, and PL-SQL are as follows:

SQL

• SQL is abbreviated as Standard Query Language.

• It has been adopted by ANSI.

• This is used by many RDBMS (Relational Database Management System) vendors.

• Both T-SQL and PL-SQL are nothing but the extensions of SQL.

T-SQL

• T-SQL is abbreviated as Transact-Structured Query Language. 

• This is Microsoft’s product.

• This works well with Microsoft SQL Server.

• T-SQL offers the degree of control for how an application works.

PL-SQL

• PL-SQL is abbreviated as Procedural Language-Structured Query Language.

• This is Oracle’s Product.

• This works well with the Oracle database server.

• PL-SQL integrates well with the SQL.

• PL-SQL is designed to extend SQL's abilities while it can be integrated well with SQL. Different features like local variables and string/data processing are added which makes the language Turing-complete.

Related questions

0 votes
1 answer
asked Jan 29, 2020 in SQL by anmolj (9k points)
0 votes
1 answer
asked Dec 10, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
0 votes
1 answer
asked Oct 19, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
asked Jan 29, 2020 in SQL by anmolj (9k points)

Browse Categories

...