Forum Stats

  • 3,827,489 Users
  • 2,260,784 Discussions
  • 7,897,278 Comments

Discussions

How to get from What I Have to What I Want

User_GP1QN
User_GP1QN Member Posts: 188 Blue Ribbon
edited May 23, 2022 9:57PM in APEX Discussions

Here is a demo page, showing what I have (unwieldy, hard-to-read paragraphs), and what I want to have (dataset that can be searched and filtered)

PLAYGROUND (oracle.com)

Is there a nifty way of doing this?

Or do I need to create a separate table, with foreign keys for the position and topic, and a column for the short-excerpted response, and a column for the source paragraph?

(edited to add: sometimes I only have the short excerpts, without the parent paragraph)

Thank you -

MT in NY (yes, I've tried repeatedly to change my profile name)