Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: Sorting collections in memory
Hello,
I want to know whether it is possible to manipulate collections using SQL insert and select?
Please take a look at these definitions:
CREATE OR REPLACE TYPE BEREGN_RESULTAT_OBJECT AS OBJECT (
ID NUMBER(32));
,PERIODE_FRA DATE
,PRIS NUMBER
and
CREATE TYPE FOUND_BEREGN_RESULTAT AS TABLE OF BEREGN_RESULTAT_OBJECT; Now I want to sort a collection (this example does NOT work):
declare
source FOUND_BEREGN_RESULTAT;
dest FOUND_BEREGN_RESULTAT;
begin
But it does not work! ?
Does anybody know how to achieve this effect without having to store the collection in a temporary database table?
Thanks,
Johan
Received on Fri Aug 27 1999 - 01:43:33 CDT