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.

Oracle Intersect

Oracle Database Basic Course

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

In Oracle, INTERSECT Operator is used to return the results of 2 or more SELECT statement. It picks the common or intersecting records from compound SELECT queries.


Syntax

SELECT expression1, expression2, ... expression_n  
FROM table1  
WHERE conditions  
INTERSECT  
SELECT expression1, expression2, ... expression_n  
FROM table2  
WHERE conditions;  

Parameters

1) expression1, expression2, ... expression_n: It specifies the columns that you want to retrieve.

2) table1, table2: It specifies the tables that you want to retrieve records from.

3) conditions: it specifies the conditions that must be fulfilled for the records to be selected.

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