Re: Collection

From: Randolf Geist <mahrah_at_web.de>
Date: Sun, 27 Jun 2010 13:59:57 -0700 (PDT)
Message-ID: <eafe38d9-fd82-4405-be32-bb63f4ca78a6_at_b35g2000yqi.googlegroups.com>

On Jun 24, 5:07 pm, The Magnet <a..._at_unsu.com> wrote:
> However, I really do not need that strange ID.   Any way to chop it
> off?

I suggest that you read Adrian Billington's article on the COLLECT function where it is also explained where these system generated types come from: http://www.oracle-developer.net/display.php?id=306

In a nutshell: You can't prevent them from being generated by the COLLECT function but you can create you own type and use the CAST function to get the desired collection type.

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

Co-author of the "OakTable Expert Oracle Practices" book: http://www.apress.com/book/view/1430226684 http://www.amazon.com/Expert-Oracle-Practices-Database-Administration/dp/1430226684 Received on Sun Jun 27 2010 - 15:59:57 CDT