Re: Several rows from Dual

From: William Robertson <williamr2019_at_googlemail.com>
Date: Tue, 17 Feb 2009 01:44:17 -0800 (PST)
Message-ID: <8dc13468-d974-4282-91e4-540393a850ef_at_t11g2000yqg.googlegroups.com>

On Feb 13, 8:56 am, Hans Mayr <mayr1..._at_gmx.de> wrote:
> Hi Maxim,
>
> Thanks. This is an elegant solution. However I wonder if there is a
> possibility which does not involve creating anything, just a plain
> "one sql statement solution" ...
>
> Best,
>
> Hans

If you don't want to create a type, you could just use one that already exists. Query all_coll_types where coll_type = 'TABLE' and elem_type_name is 'INTEGER' or 'NUMBER' and take your pick. How about ku$_objnumset? (It's used in DBMS_METADATA.) Received on Tue Feb 17 2009 - 03:44:17 CST