What is SQL, PL/SQL, T-SQL and difference between them?

Smith
Smith
None
2568 Points
74 Posts

Hi,

What is SQL, PL/SQL, T-SQL and difference between them? I want to understand the exactly difference between them

Views: 9101
Total Answered: 1
Total Marked As Answer: 1
Posted On: 11-Jan-2016 07:54

Share:   fb twitter linkedin
Answers
Brian
Brian
Moderator
2232 Points
14 Posts
         
  • SQL stands for Structured Query Language is a query language to operate on sets. It is used by almost all relational database management systems like SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, etc.
  • PL/SQL is a proprietary procedural language used by Oracle
  • PL/pgSQL is a procedural language used by PostgreSQL
  • TSQL is a proprietary procedural language used by Microsoft in SQL Server.

Procedural languages are designed to extend SQL's abilities while being able to integrate well with SQL. Several features such as local variables and string/data processing are added. These features make the language Turing-complete.

They are also used to write stored procedures is a pieces of code residing on the server to manage complex business rules that are hard or impossible to manage with pure set-based operations.

Posted On: 29-Apr-2016 23:30
 Log In to Chat