|
|
|
Re: How duplicates can be removed from an array in oracle [message #361146 is a reply to message #361128] |
Tue, 25 November 2008 03:09  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> create or replace type myarray is table of number
2 /
Type created.
SQL> declare
2 v1 myarray;
3 v2 myarray;
4 begin
5 select round(dbms_random.value(1,3)) bulk collect into v1
6 from dual connect by level <= 10;
7 for i in 1..v1.count loop
8 dbms_output.put_line('i='||i||' v='||v1(i));
9 end loop;
10 dbms_output.put_line('-----------------');
11 select distinct * bulk collect into v2 from table(v1);
12 for i in 1..v2.count loop
13 dbms_output.put_line('i='||i||' v='||v2(i));
14 end loop;
15 end;
16 /
i=1 v=1
i=2 v=2
i=3 v=2
i=4 v=2
i=5 v=2
i=6 v=2
i=7 v=1
i=8 v=1
i=9 v=2
i=10 v=3
-----------------
i=1 v=1
i=2 v=2
i=3 v=3
PL/SQL procedure successfully completed.
Regards
Michel
|
|
|