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

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

متابعة

What is the difference between Oracle and SQL server?

user-image
تم إضافة السؤال من قبل محمد الفيفي , Software Testing (Ito Quality & System Service Testing ) , Atheeb Intergraph Saudi Company
تاريخ النشر: 2016/02/14
مستخدم محذوف‎
من قبل مستخدم محذوف‎

Oracle and Ms Sql Server both represent RDBMS . The most obvious difference between the two RDBMS is the language they use,

MS SQL Server uses Transact SQL, or T-SQL, which is an extension of SQL originally developed by Sybase and used by Microsoft.

 Oracle, meanwhile, uses PL/SQL, or Procedural Language/SQL.

Both are different “flavors” or dialects of SQL and both languages have different syntax and capabilities. The main difference between the two languages is how they handle variables, stored procedures, and built-in functions. PL/SQL in Oracle can also group procedures together into packages, which can’t be done in MS SQL Server, PL/SQL is complex and potentially more powerful, while T-SQL is much more simple and easier to use.

Gayasuddin Mohammed
من قبل Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

Both are RDBMS from different vendors one is Oracle Corp product and the other is Microsoft SQL Server. And they have thier internal architecture different, but purpose is same. Thanks.

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