Hello everyone, I just started scripting in PL/SQL and I could use a bit of help with something.

I use Oracle 9, SQL*PLUS 9 and TOAD 8.

My script generate a huge list of values in a nested table. A lot of those values are identical (copies). I would like to keep only the unique in my nested table. Doing the equivalent of a SELECT DISTINCT on my nested table, preferrably outputting the result in a nested table (or at worst, something else).

I've tried a few things, and looked the doc, I couldn't find a non-ugly way to do it. Someone have an idea?