Re: Several rows from Dual

From: William Robertson <>
Date: Tue, 17 Feb 2009 01:44:17 -0800 (PST)
Message-ID: <>

On Feb 13, 8:56 am, Hans Mayr <> 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

Original text of this message