Collections with different element types

How you handle conversions between two collections that have the same collection type but different element types depends on the element type of each collection and the type of cast that the database server uses to convert one element type to another when the element types are different, as follows:
  • If a built-in cast or implicit user-defined cast exists to handle the conversion between two element types, you are not required to explicitly cast between the collection types.
  • If an explicit cast exists to handle the conversion between element types, you can perform an explicit cast on a collection.