set sql

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;