Difference between SQL and Oracle?

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

Offline electraTopic starter

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 1
  • Posts: 88
  • Karma: 1
  • I like SEO
    • Hosting discussion
Difference between SQL and Oracle?
« on: 12-10-2011, 10:27:19 »
Hi,

I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one?

Thanks
Reliable hosting? try HOSTGATOR and WEBHOSTINGHUB.

Seo Forum

Difference between SQL and Oracle?
« on: 12-10-2011, 10:27:19 »

Offline hostaddonltd

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 19
  • Karma: 0
    • Host Addon Ltd
Re: Difference between SQL and Oracle?
« Reply #1 on: 01-24-2012, 01:15:02 »
SQL is a language used to query relational database systems.

Oracle is a specific relational database system. So if you are using Oracle, you will also be using SQL to get information out of it (or an Oracle flavor of SQL).
Host Addon Ltd [nofollow] | Premium Hosting Services | Dedicated Servers | Reseller Hosting
Free Server Monitoring Service [nofollow]

Offline ivickon

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 5
  • Karma: 1
Re: Difference between SQL and Oracle?
« Reply #2 on: 02-02-2012, 12:56:13 »
Sql is structure query language like update,delete,find, etc. sql basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc

Offline allricjohnson

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 2
  • Posts: 50
  • Karma: 0
Re: Difference between SQL and Oracle?
« Reply #3 on: 04-05-2012, 05:27:29 »
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.

Offline Riyaroy

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 3
  • Karma: 0
  • Gender: Female
Re: Difference between SQL and Oracle?
« Reply #4 on: 11-21-2012, 03:55:01 »
SQL full form is structured query language
Oracle is one type of DBMS software
newbielink:http://www.esparkinfo.com/services/web-design.html [nonactive] | newbielink:http://www.esparkinfo.com/ [nonactive]

Offline ombuilders11

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 1
  • Karma: 0
Re: Difference between SQL and Oracle?
« Reply #5 on: 09-23-2013, 06:27:20 »
Sql is structured query language and oracle is a software of data base management system.
Sql language is used in oracle as a writing language.
Oracle understands only sql language.
There are so many versions of oracle like 9G,10G,11G,But Sql has no version,it is a language,only new features are added to it.
There are other software of database like--sql server 2008 etc..
from ombuilder---
newbielink:http://www.ombuilder.com [nonactive]
newbielink:http://www.ombuilder.com [nonactive]

« Last Edit: 09-23-2013, 06:30:05 by ombuilders11 »

Offline parijatziw

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 7
  • Karma: 0
Re: Difference between SQL and Oracle?
« Reply #6 on: 03-31-2014, 06:51:30 »
SQL is a language used to query relational database systems.

Oracle is a specific relational database system. So if you are using Oracle, you will also be using SQL to get information out of it (or an Oracle flavor of SQL).

Offline JDann

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 30
  • Karma: 0
  • Gender: Male
Re: Difference between SQL and Oracle?
« Reply #7 on: 06-19-2014, 01:24:16 »
  • The biggest difference between MS SQL and Oracle is Transaction control. In Oracle everything is transaction and it is not permanent until you commit. In SQL server there is no transaction control.
  • SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.
  • In my opinion, the language PL/SQL used in Oracle is complex and potentially more powerful, while the language T-SQL used in MS SQL is much more simple and easier to use.

 

Related Topics

  Subject / Started by Replies Last post
3 Replies
3255 Views
Last post 06-11-2010, 12:10:35
by ryosuzuki
15 Replies
1760 Views
Last post 02-19-2013, 23:54:09
by siyajoshi
23 Replies
2357 Views
Last post 02-04-2012, 15:06:47
by dany
6 Replies
1125 Views
Last post 10-24-2011, 02:30:13
by Hogward
0 Replies
843 Views
Last post 03-09-2012, 02:14:22
by shakemelikeapig