Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Resort a table array

Re: Resort a table array

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 Mar 2000 18:20:16 -0000
Message-ID: <953663249.4199.2.nnrp-10.9e984b29@news.demon.co.uk>

Cast it into a query which sorts it,
then cast it back into the type.

There is an example on my website
of this sort of game.

--

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

Tom Deseamus wrote in message <0IOB4.2709$l34.185208_at_news3.mia>...
>> I have created a table type array based on a select statement, then
>derived
>> a value for an element in that array. Does anyone know how I can re-sort
>> the array based on the new value?
>
>
Received on Tue Mar 21 2000 - 12:20:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US