ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

?What is the difference between t-sql and pl/sql

user-image
تم إضافة السؤال من قبل Tarek ABBOUD , معاون رئيس شعبة البرمجيات و ادارة النظم المعلوماتية , الشركة السورية للغاز
تاريخ النشر: 2017/08/14

T-SQL, also known as Transact SQL is a set of programming extensions from Sybase and Microsoft that add several features to the SQL, whereas PL SQL is a procedural language to create SQL

Amit Tiwari
من قبل Amit Tiwari , Technical Solution Consultant , Statefarm Insurance

T SQL is term from Microsoft for Programming SQL Language, PL SQL is term from Oracle for Programming Language.

Ashfaque Choudhary
من قبل Ashfaque Choudhary , Programmer Analyst , Almarai

t-sql is a part of microsoft where as pl/sql is of oracle 

Virgílio Fernandes Jr
من قبل Virgílio Fernandes Jr , Data Warehouse Analyst , Dafiti Group

T-SQL (tha stands for Transact SQL) is the SQL language used for Microsoft SQL Server, while PL-SQL is the Oracle version of the SQL Language.

Mohamed Taimour Ahmed
من قبل Mohamed Taimour Ahmed , Production Analyst , IQVIA

PL-sql is a procedural language used by oracle and T-sql is a proprietary language used by microsoft in sql server.

Mohsin Alvi
من قبل Mohsin Alvi , OSS Support And Delievery Engineer Engineer , Aircom International

Both of them are for relational database the only difference between PL/SQL and T-SQL is that PL/SQL is product of ORACLE where as T-SQL is of Microsoft product

Nitin Shinde
من قبل Nitin Shinde , Junior Analyst , Amazon

Although both systems use a version of Structured Query Language, or SQL, MS SQL Server uses Transact SQL, or T-SQL, which is an extension of SQL originally developed by Sybase and used by Microsoft. ... PL/SQL in Oracle can also group procedures together into packages, which can't be done in MS SQL Server.

bhupesh bhadekar
من قبل bhupesh bhadekar , Sr. Software Developer , Finesse Technology LLC

T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables.

anas alwekhyan
من قبل anas alwekhyan

1) t-sql is a proprietary procedural language used by Microsoft in SQL Server.

 2)PL/SQL is a proprietary procedural language used by Oracle .

Ahmed Alsadi
من قبل Ahmed Alsadi

  • 1. SQL or Structured Query Language was developed by IBM for their product "System R".

    Later ANSI made it as a Standard on which all Query Languages are based upon and have extended this to create their own DataBase Query Language suits. The first standard was SQL-86and latest being SQL:2011

    2. T-SQL or Transact-SQL was developed by Sybase and later co-owned by Microsoft SQL Server.

    3. PL/SQL or Procedural Language/SQL was Oracle Database, known as "Relation Software" that time.

TSQL is a set of procedural extensions for SQL used my MS SQL Server where as PL/SQL is procedural programming language with embedded SQL  used by all relational databases like Oracle.

TSQL is an ANSI standard structured query lnguage developed by Sybase and used by Microsoft. PL/SQL is a structed query language with programming abilities such as control structures and cursors.

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟