Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2020-12-07 03:13:23
Oracle Intersect
1809
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
এই কোর্সে যা থাকছে
৩টি বিষয়
৮০টি লাইভ ক্লাস
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.