Skip to Main Content
Forums

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!

How can I access an array in Oracle SQL?

Edisson Gabriel LópezAug 3 2021 — edited Aug 3 2021

In Oracle BI Publisher I have the following list with multiple values to select and the result is the following array:
image.pngAnd what I need is the moth and the position from the array, just like this.
image.pngThe reference of placing Field[0] is from PostgreSQL:
image.pngsource: (127) SQL Tutorial: Working with ARRAYs - YouTube

I hope you can help me, thank you.
Comments
Post Details
Added on Aug 3 2021
#report, #sql, #sqldeveloper
2 comments
4,451 views