1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Parsing data to oracle table

Discussion in 'SQL PL/SQL' started by kristenssk, Oct 18, 2018.

  1. kristenssk

    kristenssk Newly Initiated

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    India
    Hi,

    I am working on oracle 12,2.0.2. Please find below issue and advise.

    We are receiving XML files. We need to do parsing the data to Oracle tables. Can anyone please suggest what all the methods we need to follow for parsing data from XML to Oracle Tables.
    1. I have created table having column with Datatype as "XMLTYPE". ( Table name is "XML_TAB"
    2. Inserting the XML file to XML_TAB.
    3. Parsing the data using the query ( (select * from XML_TAB , XMLTABLE(.. passing COL columns)..

    For this process I would like design a process document. Can anyone please share me if have any technical design document and suggest me the procedure to do the above process.

    Thanks,
    Kris.

    Provide me if we have any
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    769
    Likes Received:
    147
    Trophy Points:
    830
    Location:
    Russian Federation
    Can explain what is your question?

    Helpful:

    1. Using XML in SQL
    2. https://www.oracle.com/technetwork/database-features/xmldb/overview/xmldb-twp-12cr1-1964803.pdf
    3. https://oracle-base.com/articles/12c/exteral-tables-and-xmltag-to-load-xml-documents-12cr2