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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

JSON_TABLE NESTED PATH total rows number

HoekApr 18 2025

Hi all,

Database 19.0 EE
Apex 24.1.5

We're processing purchaseinvoices and their invoicelines through json events.
We use views for reporting purposes. One of the views is on purchaseinvoice level, but it would come in handy if that view could
also show the total number of invoicelines, just like this invoice has 5 invoicelines:

Is there some built-in json function that does that or do i need to concoct something myself?
That would mean a massive group by in order to stay on invoice level.
I've searched docs and so on, but to no avail. That's strange since a notepad++ plugin does exactly what we need.

Hopefully my question is clear, if not please let me know.

Thanks in advance!

Regards,
Hoek

This post has been answered by Paulzip on Apr 19 2025
Jump to Answer
Comments
Post Details
Added on Apr 18 2025
3 comments
119 views