DELETE and DROP are the commands used to remove the elements of the database. DELETE command is a Data Manipulation Language command whereas, DROP is a Data Definition Language Command. The point that distinguishes DELETE  and DROP command is that DELETE  is used to remove tuples from a table and DROP is used to remove entire schema, table, domain or constraints from the database. Let us discuss some more differences between DELETE  and DROP command in SQL with the help of comparison chart … [Read more...]

SQL allows to organize the data obtained by the query. We have two clauses for organizing the data obtained from the query that are Group By and Order By clause. The point that distinguishes Group By and Order By clause is that Group By clause is used when we want to apply the aggregate function to more than one set of tuples and Order By clause is used when we want to sort the data obtained by the query. Let us discuss some differences between Group By clause and Order By clause with the … [Read more...]

Inner Join and Outer Join both are the types of Join. Join compares and combines tuples from two relations or tables. Inner Join specifies the natural join i.e. if you write a Join clause without Inner keyword then it performs the natural join operation. The potential difference between Inner Join and Outer Join is that Inner Join returns only the matching tuples from both the table and the Outer Join returns all the tuples from both the compared tables. Let us discuss some other differences … [Read more...]

JOIN and UNION are the clauses in SQL, used to combine the data of two or more relations. But the way in which they combine data and format of the result obtained, differs. The JOIN clause combines the attributes of two relations to form the resultant tuples whereas, UNION clause combines the result of two queries. Let us discuss the difference between JOIN and UNION with the help of comparison chart shown below. Content: JOIN Vs UNION Comparison Chart Definition Key Differences … [Read more...]

SQL and PL/SQL are relational database languages. SQL is a structured query language that adds, deletes, modifies or manipulates the data in the database. PL/SQL is a Procedural language which is an extension of SQL, and it holds the SQL statements within its syntax. The basic difference between SQL and PL/SQL is that in SQL a single query gets executed at a time whereas, in PL/SQL a whole block of code get executed at a time. Let us discuss some more differences between SQL and PL/SQL … [Read more...]

Among many Relational Database Management System (RDBMS), the two most popular and widely used are Oracle and SQL Server. There are many fundamental differences between Oracle and SQL Server one of the most important differences between them is the language they use. Oracle uses PL/SQL (Procedure Language SQL), and SQL Server uses T-SQL i.e. Transact-SQL. Let us discuss some more differences between Oracle and SQL Server with the help of the comparison chart shown below. Content: Oracle Vs … [Read more...]

ALTER and UPDATE are the two modifying commands of SQL. ALTER is used to modify the structure of the relations (Tables) in the database. UPDATE Command is used to modify the data stored in a relation of the database. The basic difference between ALTER and UPDATE Command is that ALTER command is a Data Definition Language command whereas the UPDATE command is a Data Manipulation Language command. Let us discuss the differences between ALTER and UPDATE Command with the help of the comparison … [Read more...]

Trigger and Procedure are Component of Advanced SQL. Trigger and Procedure both perform a specified task on their execution. The fundamental difference between Trigger and Procedure is that the Trigger executes automatically on occurrences of an event whereas, the Procedure is executed when it is explicitly invoked. Let us discuss some more differences between Trigger and Procedure with the help of a comparison chart shown below. Content: Trigger Vs Procedure Comparison Chart … [Read more...]

E-R Model and Relational Model both are the types of Data Model. Data Model describes a way to design database at physical, logical and view level. The main difference between E-R Model and Relational Model is that E-R Model is entity specific, and Relational Model is table specific. Let us discuss some differences between E-R Model and Relation model with the help of comparison chart shown below. Content: E-R Model Vs Relational Model Comparison Chart Definition Key Differences … [Read more...]

Data Definition Language (DDL) and Data Manipulation Language (DML) together forms a Database Language. The basic difference between DDL and DML is that DDL (Data Definition Language) is used to Specify the database schema database structure. On the other hand, DML (Data Manipulation Language) is used to access, modify or retrieve the data from the database. Let us discuss the differences between DDL and DML, with the help of comparison chart shown below. Content: DDL Vs DML in DBMS … [Read more...]