Difference between SQL and Oracle?

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

Previous topic - Next topic

electraTopic starter

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


hostaddonltd

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]
  •  


ivickon

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
  •  

allricjohnson

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.
River Delta India is an USA and India based Internet Marketing Services providing Company.
  •  

Riyaroy

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]
  •  


ombuilders11

#5
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]

  •  

parijatziw

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).
  •  

JDann


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


qx_1789

Both are good RDBMS but which is better? We don't get the answer for this question.Because both of them introduces newer versions with additional features.Major drawback of sql server is that it only works in windows environment.But now Microsoft is bringing its Database Software "SQL Server" to Linux.
Watch this SQL Server on Linux video here


Paavni

The main difference between Oracle Database and MS SQL Server is that MS SQL Server uses Transact-SQL/T-SQL structured query language that is an extension of SQL originally designed by Sybase and used by MS. While Oracle Database uses Procedural Language/SQL.

MS SQL Server supports D language that is not supported by Oracle Database.

Oracle Database is a proprietary software. MS SQL Server is an open source software.
newbielink:http://nationkart.com/blog/sell-handicrafts-online/ [nonactive]
  •