I'm newbie to XML data handling.
I have a file that is provided in XML format with data from an external system.
I need to load data from that file and populate some field in one or more tables.
I have two options:
1. Load the XML file directly from OS and populate the tables directly (I'm not sure if this is possible or not)
2. Load the entire XML file from OS into a CLOB or a BLOB(?) and the select the data form the CLOB and populate my tables.
I need some guidance about what is possible and how to do it.
My preferred approach if possible is to load the data directly from OS and populate the target tables without loading into the database previously.
Thanks for the help.
OS : Unix / Windows
DB Version: 11.2 or 11.1