Difference between SQL and Oracle?

[britnilinda]

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

[JeffreyMaas]

Difference between SQL and Oracle:-
1) In oracle everything is a transaction and it is not permanent until you COMMIT. In SQL server has not any transaction control.
2) SQL Server is for performance and not read consistency, But Oracle has read consistency.
3) When you setup an Oracle server, you should have one database with many schemas and tablespaces that are shared by all your users and SQL server uses logins to give you access to the SQL server.

[Bharti Mahour]

In Oracle everything is a transaction and it is not permanent.

[akashram]

SQL Server provides a Graphical User Interface to Perform Various operations on the Database. The GUI makes it easy to work with the database. But Oracle doesn’t provide Support for the GUI.

SQL server is that it is available for windows OS only and not for the Other Operating Systems such as UNIX, LINUX and SOLARIS.

[Olin Lamanna]

Perhaps the most obvious difference between the two SQL and Oracle is the language they use.

[RobMorrow71]

These are the main difference between SQL and ORACLE
Language difference.
Transaction Control difference.
Organization of Database Objects difference.

[paulbrighton]

They are two different implementations of a relational database management system. Both implement the ISO SQL standard as the language for interacting with the databases.

[Abhijit]

Hi friends,
Thanks for sharing oracle and sql related information.

[markellis312]

Nothing special difference SQL is a family of Oracle.

[StuartSpindlow]

I completely agree with all of you guys, this is really great information.

[novaco112]

Another one of the biggest differences between Oracle and MS SQL Server is transaction control. For the purposes of this article, a transaction can be defined as a group of operations or tasks that should be treated as a single unit.

[harry26]

SQL is best for learning and Oracle is also part of SQL but Oracle is more complicated then the SQL.

[patriciaprice]

The main difference between SQl and Oracle are:
SQL provides a GUI(Graphical User Interface) to Perform Various operations on the Database. While the Oracle doesn’t provide GUI interface.

Oracle has high cost than SQL

SQL is available for Windows operating System online while Oracle is available for all type of OS like Unix, Linux etc.

[lisaherry]

Applications Manager MySQL Server tracking capability helps data source directors observe the performance and accessibility to a MySQL data source village.

[novaco112]

As with Oracle, MySQL users are maintained by the database. MySQL uses a set of grant tables to keep track of users and the privileges that they can have. MySQL uses these grant tables when performing authentication, authorization and access control for users.

[StuartSpindlow]

I don't have any idea about the difference between SQL and Oracle.

[kaufenpreis]

Oracle is a software company. Their primary product is an enterprise-level relational database management system properly known as "Oracle Database". The product's name is often shortened simply to "Oracle".

SQL stands for Structured Query Language. It's a language used to interact with databases, not a database itself.

Perhaps you're referring to Microsoft SQL Server, one of Oracle's competitors? Both products use SQL, although there are minor dialect differences.

[davidsmith21]

Oracle uses Procedure Language SQL. It is Complex but powerful.

SQL Server uses Transact SQL. It is Simpler and easy to use.

[jerryperes]

Oracle: Oracle is basically a software company. Their primary product is an enterprise level relational database management system properly known as oracle database. The short name is oracle.

SQL: It stands for structured query language. It is used to interact with databases.

[Sherin]

SQL

SQL is the Structured Query Language.

Sql is like update,delete,find, etc.

sql basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc.

Sql language is used in oracle as a writing language.

Oracle

Oracle is a specific relational database system.

Oracle is one type of DBMS software.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.

The only interface available between end users and an RDBMS is SQL.

So if you are using Oracle, you will also be using SQL to get information out of it.

[jesica]

SQL is the Structured Query Language. SQL is like the update, delete, find, etc. SQL basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc. SQL language is used in oracle as a writing language. In SQL server there is no transaction control.
Oracle is a specific relational database system. Oracle is one type of DBMS software. Oracle understands only the 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. The only interface available between end-users and an RDBMS is SQL. So if you are using Oracle, you will also be using SQL to get information out of it.

[yuva12]

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