Hi,
I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one?
Thanks
SQL is a language used to query relational database systems.
Oracle is a specific relational database system. So if you are using Oracle, you will also be using SQL to get information out of it (or an Oracle flavor of SQL).
Sql is structure query language like update,delete,find, etc. sql basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc
Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system.
The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.
SQL full form is structured query language
Oracle is one type of DBMS software
Sql is structured query language and oracle is a software of data base management system.
Sql language is used in oracle as a writing language.
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.
There are other software of database like--sql server 2008 etc..
from ombuilder---
Builder in bhopal (http://www.ombuilder.com)
Property in bhopal (http://www.ombuilder.com)
SQL is a language used to query relational database systems.
Oracle is a specific relational database system. So if you are using Oracle, you will also be using SQL to get information out of it (or an Oracle flavor of SQL).
- The biggest difference between MS SQL and Oracle is Transaction control. In Oracle everything is transaction and it is not permanent until you commit. In SQL server there is no transaction control.
- SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.
- In my opinion, the language PL/SQL used in Oracle is complex and potentially more powerful, while the language T-SQL used in MS SQL is much more simple and easier to use.
Both are good RDBMS but which is better? We don't get the answer for this question.Because both of them introduces newer versions with additional features.Major drawback of sql server is that it only works in windows environment.But now Microsoft is bringing its Database Software "SQL Server (https://www.youtube.com/watch?v=7Vtl2WggqOg)" to Linux.
Watch this SQL Server on Linux video here (https://www.youtube.com/watch?v=GHEduIX9C2Y)
The main difference between Oracle Database and MS SQL Server is that MS SQL Server uses Transact-SQL/T-SQL structured query language that is an extension of SQL originally designed by Sybase and used by MS. While Oracle Database uses Procedural Language/SQL.
MS SQL Server supports D language that is not supported by Oracle Database.
Oracle Database is a proprietary software. MS SQL Server is an open source software.
Perhaps the most obvious difference between the two RDBMS is the language they use. Although both systems use a version of Structured Query Language, or SQL, MS SQL Server uses Transact SQL, or T-SQL, which is an extension of SQL originally developed by Sybase and used by Microsoft.
Post Merge: 07-11-2016, 23:50:59
DB2:Common in IBM host environments, 2 different versions for host and Windows/Linux
MySQL:Widely used open source RDBMS
Oracle NoSQL:Key-value store based on Berkeley DB Java Edition
There are many different relational database management systems (RDBMS) out there. You have probably heard about Microsoft Access, Sybase, and MySQL, but the two most popular and widely used are Oracle and MS SQL Server. Although there are many similarities between the two platforms, there are also a number of key differences. In this blog, I will be taking a look at several in particular, in the areas of their command language, how they handle transaction control and their organization of database objects.
Prophet is possessed by Oracle Corporation and can run on a wide assortment of stages like Windows, Linux, Solaris, HP-UX, and OS-X. Prophet upholds PL/SQL and SQL language to compose inquiries to get to information from its data set. SQL Server is possessed by Microsoft and must be utilized on the Windows stage.
I used oracle long time ago with a java application, great transactional functionality. However for simple webapps, I love the simplicity of MySQL. Kicks ass man!
Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system.
The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.
Users may build, change, and query databases using the standard language SQL. It is a language that is used to communicate with databases rather than a particular database system.
Oracle, on the other hand, is a specific relational database management system (RDBMS) developed by Oracle Corporation. s. Oracle provides an implementation of the SQL language, along with additional features and functionalities specific to the Oracle database.
In summary, SQL is a language used for managing databases, while Oracle is a specific database management system that incorporates the SQL language. Oracle includes additional features and capabilities that are specific to its database, making it a comprehensive and powerful RDBMS.
Visit Us At - https://firstdigiadd.com/
Oracle is a behemoth of a database system that's overkill for most use cases. It's like trying to kill a fly with a sledgehammer. SQL is a much more versatile and widely-used language that can be applied to various databases, including MySQL, PostgreSQL, and SQLite.
Oracle is a proprietary system that's mainly used in enterprise environments, and its complexity can be overwhelming for beginners. Unless you're planning to work for a large corporation, I'd recommend sticking with SQL and exploring other open-source database options.