What is the difference between SQL and Oracle?

Discussion in 'Database' started by karthikaqpt, May 23, 2016.

  1. karthikaqpt

    karthikaqpt New Member

    Joined:
    Mar 30, 2016
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Occupation:
    Working in Quality Point Technologies http://www.q
    Home Page:
    http://learnwebdevelopment.info/
    I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one?
    and tell me What is the difference between SQL and Oracle?
     
  2. Louis Zorbas

    Louis Zorbas New Member

    Joined:
    Aug 26, 2016
    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    3
    Gender:
    Male
    Your question is like asking the difference between a Ford and a Toyota truck. They both provide a comprehensive set of server-hosted and client-hosted SQL engines, tools, interfaces and support utilities to manage databases. Ignore the marketing hype and look for long-term cost-benefit analysis. Often the biggest cost is finding competent developers, DBAs and architects that are intimately familiar with the chosen DBMS. Today they're functional equivalent but very, very different in many respects. Before you choose, consider what you already know and don't have to re-learn to use the target DBMS.
     
  3. Sankalp Patil

    Sankalp Patil New Member

    Joined:
    Dec 1, 2016
    Messages:
    14
    Likes Received:
    1
    Trophy Points:
    3
    Gender:
    Male
    There are a lot of different relational database management systems (RDBMS). You may heard about Microsoft Access, Sybase, and MySQL but the two most famous and widely used are MS SQL Server and Oracle. Language: Probably, the most obvious difference between the two RDBMS is the language they use.
     
  4. Rohan09

    Rohan09 New Member

    Joined:
    Sep 15, 2017
    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    1
    Gender:
    Male
    Probably the most apparent difference between the 2 RDBMS is the language they use. Although each system uses a variation of Structured question Language or SQL, MS SQL Server uses Transact SQL, or T-SQL, which is an extension of SQL in the beginning developed by way of Sybase and used by Microsoft.
     
    shabbir likes this.
  5. persysweb

    persysweb Member

    Joined:
    Aug 1, 2017
    Messages:
    98
    Likes Received:
    18
    Trophy Points:
    8
    Location:
    India
    Home Page:
    httpS://persys.in/
    You can refer this post for the same question - https://www.go4expert.com/forums/oracle-and-sql-t26612/

    Here are the details for you -

    1. Oracle has more features and more reliable than the SQL.
    2. Oracle has broader and deeper portfolio. It is easy to integrate.
    3. Oracle is one year ahead than the SQL.
    4. When you have to deal with the huge database then Oracle is the best option.
    5. Oracle's documentation is better than the SQL.
    6. It is very secure.

    Though there are some drawbacks of Oracle.

    1. It is complex, syntax are complex.
    2. You will need DBA for administration of Oracle.
    3. Cost of maintenance is more for the Oracle.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice