-
Unique rows in a nested table
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|