Set – Oracle SQL Function

SET converts the nested table passed as an argument toa SET by removing any duplicate records from the table.

Example:

SELECT ID,NAME,SET(some_nested_table) FROM TABLE_NAME;