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
- 159 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
Apex 20.1 Complex What-If Scenario Analysis

Hello,
i am facing an complex issue where when event changes on a time series (year basis) it has an minor or mayor affect on the other following events and finally on the defined target. Meaning that when one event changes on the monetary status or any other status then to following events needs to be changed afterwards since all the events are connected and dependend (and are in relations) and belong to a bigger picture. I am talking here about running some what-if analysis on changing data.
Does anyone has an idea on how to approach this problem in an Oracle Apex workaround with PL/SQL or can recommend a way to start or tackle this problem since I need faced such issue.
Any help is appreciated. Thanks.
Answers
-
I don't see this as an Apex problem, which is a tool for creating web applications. It's not even specifically a plsql problem. It's a general technical software design problem.
Create programs for the smallest steps (your 1, 2, 3 etc)
Define the rules for the order in which these are called.
In plsql you may use dbms_scheduler chains to run program units in a specific order. You can also define events so subsequent jobs wait for other job(s) to finish first.
-
Thanks for the response. What I basically try to achieve are multiple what-if analysis for different scenarios like a Simulation of different outcomes within Oracle Apex. I hope this makes it clearier.