Here’s an alternative to the union statement for creating a collection of values using the Oracle SQL Model construct in 10g.