Search
Your cart
  • IMG
    {{cart_item.name}}
    {{cart_item.variation_attribute_name}}: {{cart_item.variation_attribute_label}}
    {{cart_item.item_unit}}: {{ setCurrency(cart_item.price)}}
    {{ setCurrency(cart_item.price*cart_item.quantity)}}
    Invalid quantity more than stock
Total :
{{setCurrency(cart.sub_total)}}
Check out

There is no item in the cart. If you want to buy, Please click here.

Anti Join

Oracle Database Basic Course

Created by :
Database, Oracle
course
Programming, Software and application
1740
2020-12-07 03:13:23

Anti-join is used to make the queries run faster. It is a very powerful SQL construct Oracle offers for faster queries.


Anti-join between two tables returns rows from the first table where no matches are found in the second table. It is opposite of a semi-join. An anti-join returns one copy of each row in the first table for which no match is found.


Anti-joins are written using the NOT EXISTS or NOT IN constructs.


SELECT  departments.department_id, departments.department_name  
    FROM   departments  
    WHERE  NOT EXISTS  
         (  
         SELECT 1  
         FROM  customer  
         WHERE customer.department_id = departments.department_id  
         )  
    ORDER BY departments.department_id;  
Oracle Trigger
Content Table
course image

Oracle Views Oracle Indexes Oracle Synonyms Oracle Sequences

Oracle Query Problem Oracle Procedure Oracle Function Oracle Cursor Oracle Trigger
Completed