I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one?
I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one?
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.
In Oracle everything is a transaction and it is not permanent.
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.
Perhaps the most obvious difference between the two SQL and Oracle is the language they use.
These are the main difference between SQL and ORACLE
Language difference.
Transaction Control difference.
Organization of Database Objects difference.
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.
Hi friends,
Thanks for sharing oracle and sql related information.
Nothing special difference SQL is a family of Oracle.
I completely agree with all of you guys, this is really great information.
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.
SQL is best for learning and Oracle is also part of SQL but Oracle is more complicated then the SQL.
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.
Applications Manager MySQL Server tracking capability helps data source directors observe the performance and accessibility to a MySQL data source village.
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.
|
Bookmarks