Results 1 to 2 of 2

Thread: Import data from xml to oracle table using get perameter() Aurgent

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    1

    Import data from xml to oracle table using get perameter() Aurgent

    how to import data from xml to pracle table using getperameter()
    if the xml is

    <?xml version="1.0"?>
    <DATA>
    <DEP NAME="Oracle" LOCATION="Chenni" >
    <EMP>
    <E NAME ="Chotu" HDATE="09-JUN-2010" SAL="10000"/>
    <E NAME ="Motu" HDATE="09-JUN-2013" SAL="10000"/>
    <E NAME ="Keetu" HDATE="09-JUN-2010" SAL="10000"/>

    </EMP>
    </DEP>

    <DEP NAME="Oracle1" LOCATION="BANGALORE" >
    <EMP>
    <E NAME ="Jai" HDATE="09-JUN-2010" SAL="10000"/>
    <E NAME ="Venky" HDATE="09-JUN-2010" SAL="10000"/>

    </EMP>
    </DEP>


    <DEP NAME="Oracle2" LOCATION="BANGALORE1" >
    </DEP>


    </DATA>

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    515
    Refer to this link for loading xml file into oracle table

    How to load xml file to oracle table

Similar Threads

  1. How to load xml file to oracle table
    By HBharadwaj in forum Oracle
    Replies: 7
    Last Post: 03-01-2013, 05:55 AM
  2. Replies: 0
    Last Post: 12-23-2012, 04:11 AM
  3. Replies: 0
    Last Post: 12-12-2012, 10:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •