Re: querying nested tables with 'order by'

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Oct 1999 10:28:36 +0100
Message-ID: <939720553.815.0.nnrp-14.9e984b29@news.demon.co.uk>

The result, where the CAST MULTISET results in the A column being repeated throughout when ordering by the B column, and the B column repeated when ordering by the A column is a known bug in the area of manipulation of memory based tables.

Sorry, I've lost my record of the bug number

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Carsten Reinhard wrote in message
<3802F2A3.F4B25C6C_at_informatik.uni-hannover.de>...

>select cast(multiset(select a, b from table(d.dopval) order by a) as
>dopnt) as test from doptest d; -- not ok
>select cast(multiset(select a, b from table(d.dopval) order by b) as
>dopnt) as test from doptest d; -- not ok
>
>Has anyone any experience/solution for this problem ??
>
Received on Tue Oct 12 1999 - 04:28:36 CDT