Skip to main content

CONCATENATION

Short Description

Rows from two data sources are brought together in the same way as a Union-All operation.

Detailed Description​

Where you have different conditions with an OR clause, CONCATENATION is useful to combine data and can use good execution plans with the aid of appropriate indexes. E.g.

SELECT l.header_id, l.line_id, l.revenue_amount
  FROM so_lines_all l
 WHERE l.parent_line_id = :b1
    OR l.service_parent_line_id = :b1;

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.