I don't have any idea about the difference between SQL and Oracle.
I don't have any idea about the difference between SQL and Oracle.
Oracle is a software company. Their primary product is an enterprise-level relational database management system properly known as "Oracle Database". The product's name is often shortened simply to "Oracle".
SQL stands for Structured Query Language. It's a language used to interact with databases, not a database itself.
Perhaps you're referring to Microsoft SQL Server, one of Oracle's competitors? Both products use SQL, although there are minor dialect differences.
Oracle uses Procedure Language SQL. It is Complex but powerful.
SQL Server uses Transact SQL. It is Simpler and easy to use.
Oracle: Oracle is basically a software company. Their primary product is an enterprise level relational database management system properly known as oracle database. The short name is oracle.
SQL: It stands for structured query language. It is used to interact with databases.
SQL
SQL is the Structured Query Language.
Sql is like update,delete,find, etc.
sql basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc.
Sql language is used in oracle as a writing language.
Oracle
Oracle is a specific relational database system.
Oracle is one type of DBMS software.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.
The only interface available between end users and an RDBMS is SQL.
So if you are using Oracle, you will also be using SQL to get information out of it.
SQL is the Structured Query Language. SQL is like the update, delete, find, etc. SQL basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc. SQL language is used in oracle as a writing language. In SQL server there is no transaction control.
Oracle is a specific relational database system. Oracle is one type of DBMS software. Oracle understands only the 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. The only interface available between end-users and an RDBMS is SQL. So if you are using Oracle, you will also be using SQL to get information out of it.
Perhaps the most obvious difference between the two RDBMS is the language they use. ... The main difference between the two languages is how they handle variables, stored procedures, and built-in functions. PL/SQL in Oracle can also group procedures together into packages, which can't be done in MS SQL Server.
|
Bookmarks