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