Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access nested table column's first element using SQL

JackKFeb 17 2022

Hi!
I have a view which has a column named NUMARR_COL containing array of numbers (collection or nested table). I want to filter rows from this view to have only rows where the first element NUMARR_COL is less than 100.
What is the best way to do this in DB 19c?
Best regards,
Jacek

Comments
Post Details
Added on Feb 17 2022
4 comments
449 views