asked on

Displaying XML data extract on a form / Oracle

I have an XML file extract with names of people and other details. How do I make this data available on a form of some sorts so end users can perform all kinds of searches on the data. i. e. First Name/Last name text search or even filter the data further using drop down that users can choose from?

I am thinking of loading the XML file into an Oracle database and then display the data as a form on Oracle Apex. However I have no prior experience in Oracle Apex, so I'm assuming it has text search, drilling down features etc.

Ps - this XML data load could end up being a weekly /monthly data load.

Really appreciate your help/suggestions.

Thanks, Ben

slightwv (䄆 Netminder)

I'm not an APEX person so I'm not sure how much it has built in and how much you need to code.

Oracle can easily index and search XML using Oracle Text:
http://docs.oracle.com/database/122/CCAPP/understanding-oracle-text-application-development.htm#CCAPP9004
http://docs.oracle.com/database/122/CCAPP/searching-document-sections-in-oracle-text.htm#CCAPP9309

Oracle can also perform XLS transformations.

Oracle has MANY ways to extract and transform XML into whatever you wish so you aren't stuck with APEX. Use pretty much whatever programming language you are familiar with.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.