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.

How to return multiple fields using date range with table function

LotsVivJan 4 2021

Hi I am on 12c, release 12.1.0.2. Application is APEX (5.1.4). I am wanting to enhance a working table function to return with multiple date range.
The current working table function returns test data that is like this:
select * from table (capacity_date_delivery ('1/11/2021')) where ent_owner ='MGAG' and point_id = 9002780;
image.pngThis is what is displayed in APEX report.
I would like for the table function to return date range up to 7 days. I can't loop the calling of table function as it will return first 5 fields on each call. And I need the value (IE: 101549) which is "month mdq" to pivot on the date range field IE: JAN_11_21, JAN_12_21..... This data is to be shown in APEX as a report. I do have this working in APEX as one date range. Thank you. I have code to support this but I am not wanting to post them all on here. If I have not provided enough information, can I message someone in private to share more info?

Comments

Post Details

Added on Jan 4 2021
1 comment
65 views