Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the difference between Oracle and SQL server?

user-image
Question ajoutée par محمد الفيفي , Software Testing (Ito Quality & System Service Testing ) , Atheeb Intergraph Saudi Company
Date de publication: 2016/02/14
Utilisateur supprimé
par Utilisateur supprimé

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
par 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.

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?