What Do Branches and Sequels Allow Planners to Do in APEX?
In Oracle APEX (Application Express), Branches and Sequences (not "sequels") are distinct navigation/flow controls:
Branches
Direct page flow after page submission (post-processing).
- Conditional navigation: Route to different pages based on values, validations, or user roles.
- Multi-path workflows: E.g., "Approve" → Page 10; "Reject" → Page 11; "Escalate" → Page 12.
- Redirect vs. Branch to Page: Control browser history and session state.
- Branch points: On Submit (after processing), On Load (before rendering), After Processing.
Sequences
Usually refers to Page Sequence (wizard steps) or Database Sequences (PK generation).
- Page Sequence / Wizard: Defines ordered steps (Step 1 → 2 → 3) with "Next/Previous" logic, validation per step, and branch targets on completion.
- Database Sequence: Generates unique IDs (e.g.,
ORDER_ID_SEQ.NEXTVAL) for primary keys—critical for multi-user concurrency.
Combined Power
- Branches handle decision logic; Sequences handle ordering & identity.
- Together: Build complex, stateful workflows (approvals, onboarding, multi-step forms) with clean navigation and reliable keys.
If you meant "Sequels" as a specific APEX plugin or feature, clarify—standard APEX uses "Sequences."