Learn oracle - oracle tutorial - Oracle minus - oracle examples - oracle programs

What is Oracle MINUS ?

• MINUS operator is used to return all rows in the first SELECT statement that are not returned by the second SELECT statement.
• Each SELECT statement has a dataset and the MINUS operator returns all documents from the first dataset and then removes all documents from the second dataset.

Syntax:

SELECT column_name
FROM table1_name
MINUS
Select column_name
FROM table2_name

click below button to copy the code. By - oracle tutorial - team

Copy Code

Example:

SELECT name
FROM wikitechy_employee
MINUS
Select name 
FROM wikitechy_employee1;

click below button to copy the code. By - oracle tutorial - team

Copy Code

Code Explanation:

Before Execution:

• Table1 is shown

• Table2 is shown

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

AFTER EXECUTION:

1. Using the “MINUS statement“ The given query returns only rows returned by the first query but not by the second.

Oracle Union - Oracle UnionAll - Oracle Except - Oracle Intersect

This tutorial provides an in depth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning