Difference between SQL and Oracle?

Started by electra, 12-10-2011, 08:27:19

Previous topic - Next topic

a4nuser

#10
Perhaps the most obvious difference between the two RDBMS is the language they use. 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.

Post Merge: 07-11-2016, 23:50:59


DB2:Common in IBM host environments, 2 different versions for host and Windows/Linux

MySQL:Widely used open source RDBMS

Oracle NoSQL:Key-value store based on Berkeley DB Java Edition
  •  


Gharkul

There are many different relational database management systems (RDBMS) out there. You have probably heard about Microsoft Access, Sybase, and MySQL, but the two most popular and widely used are Oracle and MS SQL Server. Although there are many similarities between the two platforms, there are also a number of key differences. In this blog, I will be taking a look at several in particular, in the areas of their command language, how they handle transaction control and their organization of database objects.
  •  


dark404

Prophet is possessed by Oracle Corporation and can run on a wide assortment of stages like Windows, Linux, Solaris, HP-UX, and OS-X. Prophet upholds PL/SQL and SQL language to compose inquiries to get to information from its data set. SQL Server is possessed by Microsoft and must be utilized on the Windows stage.

dark404

I used oracle long time ago with a java application, great transactional functionality. However for simple webapps, I love the simplicity of MySQL. Kicks ass man!

f1dark

Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system.

The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.


firstdigiadd

Users may build, change, and query databases using the standard language SQL. It is a language that is used to communicate with databases rather than a particular database system.
Oracle, on the other hand, is a specific relational database management system (RDBMS) developed by Oracle Corporation. s. Oracle provides an implementation of the SQL language, along with additional features and functionalities specific to the Oracle database.

In summary, SQL is a language used for managing databases, while Oracle is a specific database management system that incorporates the SQL language. Oracle includes additional features and capabilities that are specific to its database, making it a comprehensive and powerful RDBMS.

Visit Us At - https://firstdigiadd.com/
  •