Difference between SQL and Oracle?

Author Topic: Difference between SQL and Oracle?  (Read 17701 times)

Offline a4nuser

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 5
  • Posts: 91
  • Karma: 0
Difference between SQL and Oracle?
« Reply #10 on: 07-11-2016, 23:49:03 »
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
« Last Edit: 07-11-2016, 23:50:59 by a4nuser »


Offline Gharkul

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 12
  • Karma: 0
Re: Difference between SQL and Oracle?
« Reply #11 on: 08-08-2016, 04:22:09 »
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.


Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 221
  • Karma: 0
    • F1removals.co.uk
Re: Difference between SQL and Oracle?
« Reply #12 on: 08-26-2022, 05:22:18 »
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.

Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 221
  • Karma: 0
    • F1removals.co.uk
Re: Difference between SQL and Oracle?
« Reply #13 on: 09-20-2022, 05:54:33 »
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!

Offline f1dark

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 0
  • Posts: 154
  • Karma: 0
  • Gender: Female
  • F1 Removals is the top removals company in the UK,
    • F1removals.co.uk
Re: Difference between SQL and Oracle?
« Reply #14 on: 10-06-2022, 05:29:57 »
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.


 

Related Topics

  Subject / Started by Replies Last post
6 Replies
9986 Views
Last post 10-06-2022, 05:28:54
by f1dark
23 Replies
10270 Views
Last post 02-04-2012, 13:06:47
by dany
6 Replies
4930 Views
Last post 10-24-2011, 00:30:13
by Hogward
1 Replies
5525 Views
Last post 11-09-2017, 23:38:57
by damponting44
0 Replies
1650 Views
Last post 12-16-2015, 02:31:55
by chinmay.sahoo