Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 473 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to return multiple fields using date range with table function

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;
This 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?
Answers
-
Hi,
... 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?
No need for that; just post everything (including your existing function, CREATE TABLE and INSERT statements for the sample data, the results you want from that data, and an explanation of how you get those results from that data) right in this space. If some of the data is private, then don't post the actual data: make up something that behaves like your real data, but isn't sensitive.