CE_UNION_ALL computes the union of two tables which need to have identical schemas.

Example:
 ot_all_peoples1 = CE_UNION_ALL (:lt_peoples, :it_managers); 
Is equivalent to
ot_all_peoples2 = SELECT * FROM :lt_peoples UNION ALL SELECT * FROM :it_managers;

Related questions