Bulk Updates in Oracle from XML File

From: Kiran Dalvi (rayoflight_kiran_at_yahoo.com)
Date: 12/24/03

  • Next message: ITM: "JDBC/ODBC user issues accessing SQL Server 2000 database" 
    Date: 24 Dec 2003 01:02:34 -0800

    Hi,
     
      I have following problem scenario .....
     
      I have a XML of the format ....
      <Data>
       <Employee>
         <EmpName>Kiran</EmpName>
         <EmpID>100</EmpID>
       </Employee>
       <Employee>
         <EmpName>Faheem</EmpName>
         <EmpID>1000</EmpID>
       </Employee>
         ..
         ..
         .. ..... I have such 30000+ blocks corressponding to 30000+
    Employees.
      </Data>
     
       Now, I have a DB design with following columns .....
      1) EmpName Varchar2(64)
      2) EmpID Number(64)

     
    Here I want to parse this XML and persist the data from that XML into
    DB "efficiently".
    I don't want to use conventional INSERTs.
     
    How can I go about it ?
     
    Thanks,
    --Kiran

  • Next message: ITM: "JDBC/ODBC user issues accessing SQL Server 2000 database"

    Relevant Pages

    • Re: Word 2003 XML
      ... So there are many sites That are written that have information Mac users could use, but can't get at it because FronTPage was used to design it, And therefore Only IE users can view it. ... If Microsoft really had made a life's work out of not using any standards, ... group chose the XML format that Microsoft adopted over the open format ...
      (microsoft.public.mac.office.word)
    • Re: Help w/Self-Join Hierarchy Query
      ... > EXPLICIT then I may find the answer in there. ... > Then there is the ever popular employee - manager adjacency. ... > FOR XML SELF ...
      (microsoft.public.sqlserver.programming)
    • Stand alone Shredding in SQL Server 2005
      ... what I've read it will have to be some type of bulk processing. ... from the command line or bulk insert from T-SQL. ... the xml I want to shred: ...
      (microsoft.public.sqlserver.xml)
    • Re: Deserialize Business Object
      ... Dim Employee As Employee = CType, ... I am having an issue deserializing a business object from a SQL stored ... As the XML being returned is an XML fragment due to not having a single ... Create a new XmlDocument, add the root element to it, then ...
      (microsoft.public.dotnet.xml)
    • csv with parent-child columns to xml
      ... Can any of the commercial conversion tools convert csv files ... The xml structure for each file would be ... The number of child elements varies. ...
      (microsoft.public.dotnet.xml)