Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    Registered User
    Join Date
    Jul 2013
    Posts
    51

    Difference between SQL and Oracle?

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

  2. #2
    Registered User
    Join Date
    Jun 2014
    Posts
    23
    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.

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

  4. #4
    Senior Member
    Join Date
    May 2013
    Posts
    198
    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.

  5. #5
    Senior Member
    Join Date
    Nov 2013
    Posts
    347
    Perhaps the most obvious difference between the two SQL and Oracle is the language they use.

  6. #6
    Registered User
    Join Date
    Jan 2014
    Posts
    56
    These are the main difference between SQL and ORACLE
    Language difference.
    Transaction Control difference.
    Organization of Database Objects difference.

  7. #7
    Senior Member
    Join Date
    Jun 2014
    Location
    Pasadena, CA 91101
    Posts
    117
    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.

  8. #8
    Registered User
    Join Date
    Sep 2014
    Location
    Delhi
    Posts
    41
    Hi friends,
    Thanks for sharing oracle and sql related information.

  9. #9
    Member
    Join Date
    Nov 2014
    Location
    Pakistan
    Posts
    56
    Nothing special difference SQL is a family of Oracle.

  10. #10
    Senior Member
    Join Date
    Jun 2014
    Location
    United Kingdom
    Posts
    128
    I completely agree with all of you guys, this is really great information.

  11. #11
    Member
    Join Date
    Dec 2014
    Posts
    54
    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.

  12. #12
    Senior Member
    Join Date
    Nov 2014
    Posts
    113
    SQL is best for learning and Oracle is also part of SQL but Oracle is more complicated then the SQL.

  13. #13
    Registered User
    Join Date
    Dec 2014
    Posts
    1
    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.

  14. #14
    Junior Member
    Join Date
    Nov 2014
    Posts
    22
    Applications Manager MySQL Server tracking capability helps data source directors observe the performance and accessibility to a MySQL data source village.

  15. #15
    Member
    Join Date
    Dec 2014
    Posts
    54
    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.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.