How to get distinct values from nested table in oracle?

Member

by lizzie , in category: MySQL , 10 days ago

How to get distinct values from nested table in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by cali_green , 9 days ago

@lizzie 

To get distinct values from a nested table in Oracle, you can use the TABLE operator to convert the nested table into a result set and then apply the DISTINCT keyword to get unique values. Here is an example:

1
2
SELECT DISTINCT column_value 
FROM TABLE(nested_table_column);


Replace column_value with the column name of the nested table and nested_table_column with the name of the nested table column in your query.


This query will return distinct values from the nested table column.