Re: Sorter of PL/SQL Table Utility

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 29 Apr 1999 04:16:43 GMT
Message-ID: <7g8mfb$nm0$1_at_nntp.csufresno.edu>


Mr. Kyte,

Is there any chance you could post a short description of what that sort is doing? I was expecting to see something like a traditional sort routine using only PL/SQL and a PL/SQL table, and obviously this is not.

Thank you,
Steve Cosner

In article <372910f3.96776757_at_192.86.155.100>, Thomas Kyte <tkyte_at_us.oracle.com> wrote:
>A copy of this was sent to "Adam Tadjkarimi" <adamt_at_hsltd.com>
>(if that email address didn't require changing)
>On Tue, 27 Apr 1999 09:10:01 -0500, you wrote:
>
>>Does any kind fellow netter have a good PL/SQL code which can sort elements
>>of a PL/SQL table and would like to share it graciously?
>>
>>adamt_at_hsltd.com
>
>
>I'll show you how to use SQL to sort the table in 7.x and another,
>easier way in 8.x.
>
>First the 7.x way. You can use the 'call plsql from sql' feature to
>make your plsql an in memory SQL table as follows:
<snip> Received on Thu Apr 29 1999 - 06:16:43 CEST

Original text of this message