Home » Developer & Programmer » JDeveloper, Java & XML » Need to insert data from XML file into Oracle Table (very urgent) (Oracle 11g)
Need to insert data from XML file into Oracle Table (very urgent) [message #651769] Tue, 24 May 2016 22:09 Go to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Hi All,

I have sample XML file as below:
Please send me the Oracle procedure to insert this data into the table

<?xml version="1.0" encoding="UTF-8" ?>
<badges>
<row UserId="3718" Name="Teacher" Date="2008-09-15T08:55:03.923"/>
<Reading TimeStamp="2016-03-01 08:30:00" RawReading="0" />
<Reading TimeStamp="2016-03-01 08:35:00" RawReading="0.1" />
<Reading TimeStamp="2016-03-01 08:40:00" RawReading="0.2" />
<row UserId="994" Name="Teacher" Date="2008-09-15T08:55:03.957"/>
<Reading TimeStamp="2016-03-01 08:30:00" RawReading="0.3" />
<Reading TimeStamp="2016-03-01 08:35:00" RawReading="0.4" />
<Reading TimeStamp="2016-03-01 08:40:00" RawReading="0.2" />
</badges>

[Updated on: Tue, 24 May 2016 22:10]

Report message to a moderator

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651771 is a reply to message #651769] Tue, 24 May 2016 22:22 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

>Need to insert data from XML file into Oracle Table (very urgent)
Please explain why it is URGENT for us to solve this problem for you.

>Please send me the Oracle procedure to insert this data into the table
We do NOT provide coding on demand services here.

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651773 is a reply to message #651771] Tue, 24 May 2016 22:27 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
I need to use the code in my environment as the client requirement is urgent and the XML file is very huge. I just created the sample XML accordingly, if i can get the answer for that, i can resolve the huge file extraction accordingly. I am trying to find it in google, but i couldn't manage to find the proper answer since last day.
That's why i mentioned it is as urgent.
Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651775 is a reply to message #651773] Tue, 24 May 2016 22:41 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
https://www.google.com/webhp?hl=en&tab=ww#hl=en&q=loading+xml+file+into+oracle+table+example
Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651776 is a reply to message #651775] Tue, 24 May 2016 22:52 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
I have gone through all those links, but I couldn't find the solution, that's why I'm asking for the solution here.

By using those links, I managed to write the code below. But it is returning with multiple values like each /badges/row in the XML reading the data twice from the /badges/Reading.
So I want to get rid off that recurring reading values.

SELECT  UserId, 
        Name
        ,to_timestamp(dt, 'YYYY-MM-DD"T"HH24:MI:SS.FF3') dt
        ,RawReading
      
      FROM ( SELECT SYS_NC_ROWINFO$ as xml_data FROM TEST_XML )
           ,XMLTable('for $i in /badges/row
                                return $i'
                    passing xml_data
                    columns UserId NUMBER path '@UserId',
                            Name VARCHAR2(50) path '@Name',
                            dt VARCHAR2(25) path '@Date'
                    )
                    
           ,XMLTable('for $j in /badges/Reading
                                return $j'
                    passing xml_data
                    columns RawReading varchar2(10) path '@RawReading'
                    );  

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651778 is a reply to message #651769] Wed, 25 May 2016 00:08 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Please send me the Oracle procedure to insert this data into the table


Which one?
We have none.

Post the CREATE TABLE statement for the target table.
Post the result you want for the XML you gave.
Read and apply How to use [code] tags and make your code easier to read.

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651781 is a reply to message #651776] Wed, 25 May 2016 01:57 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8751
Registered: November 2002
Location: California, USA
Senior Member
Part of the problem is that your XML is written in such a manner that there is no way to tell which Reading belongs to which row.

If you were to fix your XML like so:
SCOTT@orcl_12.1.0.2.0> CREATE TABLE test_xml AS
  2  SELECT XMLTYPE
  3  	      ('<?xml version="1.0" encoding="UTF-8" ?>
  4  		<badges>
  5  		  <row UserId="3718" Name="Teacher" Date="2008-09-15T08:55:03.923">
  6  		    <Reading TimeStamp="2016-03-01 08:30:00" RawReading="0" />
  7  		    <Reading TimeStamp="2016-03-01 08:35:00" RawReading="0.1" />
  8  		    <Reading TimeStamp="2016-03-01 08:40:00" RawReading="0.2" />
  9  		  </row>
 10  		  <row UserId="994" Name="Teacher" Date="2008-09-15T08:55:03.957">
 11  		    <Reading TimeStamp="2016-03-01 08:30:00" RawReading="0.3" />
 12  		    <Reading TimeStamp="2016-03-01 08:35:00" RawReading="0.4" />
 13  		    <Reading TimeStamp="2016-03-01 08:40:00" RawReading="0.2" />
 14  		  </row>
 15  		</badges>') sys_nc_rowinfo$
 16  FROM   DUAL
 17  /

Table created.


-- then you could select it like so (and insert it wherever you want):
SCOTT@orcl_12.1.0.2.0> COLUMN name FORMAT A15
SCOTT@orcl_12.1.0.2.0> COLUMN dt   FORMAT A31
SCOTT@orcl_12.1.0.2.0> SELECT x1.UserId, x1.Name, TO_TIMESTAMP (x1.dt, 'YYYY-MM-DD"T"HH24:MI:SS.FF3') dt, x2.RawReading
  2  FROM   test_xml t,
  3  	    XMLTable
  4  	      ('/badges/row'
  5  	       PASSING t.sys_nc_rowinfo$
  6  	       COLUMNS
  7  		 UserId      NUMBER	    PATH  '@UserId',
  8  		 Name	     VARCHAR2(50)   PATH  '@Name',
  9  		 dt	     VARCHAR2(25)   PATH  '@Date',
 10  		 readings    XMLTYPE	    PATH  '/row/Reading') x1,
 11  	     XMLTable
 12  	       ('/Reading'
 13  		PASSING x1.readings
 14  		COLUMNS
 15  		  RawReading  VARCHAR2(10)  PATH  '@RawReading') x2
 16  /

    USERID NAME            DT                              RAWREADING
---------- --------------- ------------------------------- ----------
      3718 Teacher         15-SEP-08 08.55.03.923000000 AM 0
      3718 Teacher         15-SEP-08 08.55.03.923000000 AM 0.1
      3718 Teacher         15-SEP-08 08.55.03.923000000 AM 0.2
       994 Teacher         15-SEP-08 08.55.03.957000000 AM 0.3
       994 Teacher         15-SEP-08 08.55.03.957000000 AM 0.4
       994 Teacher         15-SEP-08 08.55.03.957000000 AM 0.2

6 rows selected.

[Updated on: Wed, 25 May 2016 02:03]

Report message to a moderator

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651814 is a reply to message #651781] Wed, 25 May 2016 10:49 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Hi, this approach is working fine.
But, when I create the XML table using:

CREATE TABLE test_xml OF XMLTYPE
XMLTYPE STORE AS SECUREFILE BINARY XML;


And try to isnert the data like this:

INSERT INTO test_xml VALUES( 
xmltype(bfilename('TESTING','test.xml'),nls_charset_id('AL32UTF8')));
commit;


After inserting the data into test_ml table in this way, and i tried to run the procedure what you had written,

SCOTT@orcl_12.1.0.2.0> SELECT x1.UserId, x1.Name, TO_TIMESTAMP (x1.dt, 'YYYY-MM-DD"T"HH24:MI:SS.FF3') dt, x2.RawReading
  2  FROM   test_xml t,
  3  	    XMLTable
  4  	      ('/badges/row'
  5  	       PASSING t.sys_nc_rowinfo$
  6  	       COLUMNS
  7  		 UserId      NUMBER	    PATH  '@UserId',
  8  		 Name	     VARCHAR2(50)   PATH  '@Name',
  9  		 dt	     VARCHAR2(25)   PATH  '@Date',
 10  		 readings    XMLTYPE	    PATH  '/row/Reading') x1,
 11  	     XMLTable
 12  	       ('/Reading'
 13  		PASSING x1.readings
 14  		COLUMNS
 15  		  RawReading  VARCHAR2(10)  PATH  '@RawReading') x2
 16  /


It came with the empty result.

The reason why I want to create the table as I mentioned is because the XML file that I'm going to use is in big size.
I am unable to create the table with that huge XML data (in your way of creating XCML table).

Sample file has been attached.
  • Attachment: SAMPLE.txt
    (Size: 29.45KB, Downloaded 93 times)
Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651815 is a reply to message #651814] Wed, 25 May 2016 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BlackSwan wrote on Wed, 25 May 2016 05:22
Welcome to this forum

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

>Need to insert data from XML file into Oracle Table (very urgent)
Please explain why it is URGENT for us to solve this problem for you.

>Please send me the Oracle procedure to insert this data into the table
We do NOT provide coding on demand services here.


Michel Cadot wrote on Wed, 25 May 2016 07:08

Quote:
Please send me the Oracle procedure to insert this data into the table


Which one?
We have none.

Post the CREATE TABLE statement for the target table.
Post the result you want for the XML you gave.
Read and apply How to use [code] tags and make your code easier to read.

[Updated on: Wed, 25 May 2016 11:17]

Report message to a moderator

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651817 is a reply to message #651815] Wed, 25 May 2016 12:59 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
The Create table is as follows:
Toggle Spoiler

[Updated on: Wed, 25 May 2016 13:35] by Moderator

Report message to a moderator

Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651818 is a reply to message #651817] Wed, 25 May 2016 13:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 25 May 2016 18:16
BlackSwan wrote on Wed, 25 May 2016 05:22
Welcome to this forum

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

>Need to insert data from XML file into Oracle Table (very urgent)
Please explain why it is URGENT for us to solve this problem for you.

>Please send me the Oracle procedure to insert this data into the table
We do NOT provide coding on demand services here.


Michel Cadot wrote on Wed, 25 May 2016 07:08

Quote:
Please send me the Oracle procedure to insert this data into the table


Which one?
We have none.

Post the CREATE TABLE statement for the target table.
Post the result you want for the XML you gave.
Read and apply How to use [code] tags and make your code easier to read.


Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651820 is a reply to message #651815] Wed, 25 May 2016 14:08 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8751
Registered: November 2002
Location: California, USA
Senior Member
The problem is that your tags in your XML are different from the tags in the sample data that you previously provided. The following demonstrates how to get a couple of values from each tag in your new data. You should be able to grasp the pattern and add any additional values that you like or not select any values that you don't want. You should not need any more xml tables, just add columns. Bear in mind that the xml tags are case sensitive.

SCOTT@orcl_12.1.0.2.0> CREATE TABLE test_xml OF XMLTYPE
  2  XMLTYPE STORE AS SECUREFILE BINARY XML
  3  /

Table created.

SCOTT@orcl_12.1.0.2.0> CREATE OR REPLACE DIRECTORY testing AS 'c:\my_oracle_files'
  2  /

Directory created.

SCOTT@orcl_12.1.0.2.0> INSERT INTO test_xml VALUES(
  2  xmltype(bfilename('TESTING','test.xml'),nls_charset_id('AL32UTF8')))
  3  /

1 row created.

SCOTT@orcl_12.1.0.2.0> commit
  2  /

Commit complete.

SCOTT@orcl_12.1.0.2.0> SELECT x1.irn, x1.source,
  2  	    x2.meterirn, x2.metername,
  3  	    x4.uom, x4.direction,
  4  	    TO_DATE (x5.readtime, 'YYYY-MM-DD HH24:MI:SS') readtime,
  5  	    x5.rawreading
  6  FROM   test_xml t,
  7  	    XMLTABLE
  8  	      ('//MeterReadings'
  9  	       PASSING t.SYS_NC_ROWINFO$
 10  	       COLUMNS
 11  		 irn		 NUMBER        PATH '@Irn',
 12  		 source 	 VARCHAR2(6)   PATH '@Source',
 13  		 meters 	 XMLTYPE       PATH '/MeterReadings/Meter',
 14  		 intervaldatas	 XMLTYPE       PATH '/MeterReadings/IntervalData') x1,
 15  	    XMLTABLE
 16  	      ('/Meter'
 17  	       PASSING x1.meters
 18  	       COLUMNS
 19  		 meterirn	 NUMBER        PATH '@MeterIrn',
 20  		 metername	 NUMBER        PATH '@MeterName') x2,
 21  	    XMLTABLE
 22  	      ('/IntervalData'
 23  	       PASSING x1.intervaldatas
 24  	       COLUMNS
 25  		 intervalspecs	 XMLTYPE       PATH '/IntervalData/IntervalSpec',
 26  		 readings	 XMLTYPE       PATH '/IntervalData/Reading') x3,
 27  	    XMLTABLE
 28  	      ('/IntervalSpec'
 29  	       PASSING x3.intervalspecs
 30  	       COLUMNS
 31  		 uom		 VARCHAR2(4)   PATH '@UOM',
 32  		 direction	 VARCHAR2(9)   PATH '@Direction') x4,
 33  	    XMLTABLE
 34  	      ('/Reading'
 35  	       PASSING x3.readings
 36  	       COLUMNS
 37  		 readtime	 VARCHAR2(19)  PATH '@TimeStamp',
 38  		 rawreading	 NUMBER        PATH '@RawReading') x5
 39  ORDER  BY 1, 2, 3, 4, 5, 6, 7
 40  /

       IRN SOURCE   METERIRN  METERNAME UOM  DIRECTION READTIME             RAWREADING
---------- ------ ---------- ---------- ---- --------- -------------------- ----------
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 08:30:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 08:45:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 09:00:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 09:15:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 09:30:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 09:45:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 10:00:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 10:15:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 10:30:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 10:45:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 11:00:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 11:15:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 11:30:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 11:45:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 12:00:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 12:15:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 12:30:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 12:45:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 13:00:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 13:15:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 13:30:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 13:45:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 14:00:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 14:15:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 14:30:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 14:45:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 15:00:00        .01
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 15:15:00          0
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 15:30:00        .03
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 15:45:00        .03
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 16:00:00        .03
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 16:15:00        .03
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 16:30:00        .04
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 16:45:00        .02
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 17:00:00        .05
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 17:15:00        .12
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 17:30:00        .12
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 17:45:00        .13
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 18:00:00        .12
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 18:15:00        .11
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 18:30:00        .13
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 18:45:00        .12
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 19:00:00        .13
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 19:15:00        .15
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 19:30:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 19:45:00        .15
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 20:00:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 20:15:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 20:30:00        .15
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 20:45:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 21:00:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 21:15:00        .15
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 21:30:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 21:45:00        .15
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 22:00:00        .14
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 22:15:00         .1
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 22:30:00        .03
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 22:45:00        .02
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 23:00:00        .02
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 23:15:00        .02
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 23:30:00        .02
        26 Remote         26     123456 ABCD Delivered 01-MAR-2016 23:45:00        .03
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 00:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 00:15:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 00:30:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 00:45:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 01:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 01:15:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 01:30:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 01:45:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 02:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 02:15:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 02:30:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 02:45:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 03:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 03:15:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 03:30:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 03:45:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 04:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 04:15:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 04:30:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 04:45:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 05:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 05:15:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 05:30:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 05:45:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 06:00:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 06:15:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 06:30:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 06:45:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 07:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 07:15:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 07:30:00        .01
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 07:45:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 08:00:00          0
        26 Remote         26     123456 ABCD Delivered 02-MAR-2016 08:15:00        .01
        26 Remote         26     123456 ABCD Received  01-MAR-2016 08:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 08:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 09:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 09:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 09:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 09:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 10:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 10:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 10:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 10:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 11:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 11:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 11:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 11:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 12:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 12:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 12:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 12:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 13:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 13:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 13:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 13:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 14:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 14:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 14:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 14:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 15:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 15:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 15:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 15:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 16:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 16:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 16:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 16:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 17:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 17:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 17:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 17:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 18:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 18:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 18:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 18:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 19:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 19:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 19:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 19:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 20:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 20:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 20:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 20:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 21:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 21:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 21:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 21:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 22:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 22:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 22:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 22:45:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 23:00:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 23:15:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 23:30:00          0
        26 Remote         26     123456 ABCD Received  01-MAR-2016 23:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 00:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 00:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 00:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 00:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 01:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 01:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 01:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 01:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 02:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 02:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 02:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 02:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 03:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 03:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 03:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 03:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 04:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 04:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 04:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 04:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 05:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 05:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 05:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 05:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 06:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 06:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 06:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 06:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 07:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 07:15:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 07:30:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 07:45:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 08:00:00          0
        26 Remote         26     123456 ABCD Received  02-MAR-2016 08:15:00          0
        26 Remote         26     123456 XYZ            01-MAR-2016 08:45:00      249.1
        26 Remote         26     123456 XYZ            01-MAR-2016 09:00:00      249.4
        26 Remote         26     123456 XYZ            01-MAR-2016 09:15:00      249.5
        26 Remote         26     123456 XYZ            01-MAR-2016 09:30:00      249.6
        26 Remote         26     123456 XYZ            01-MAR-2016 09:45:00      249.1
        26 Remote         26     123456 XYZ            01-MAR-2016 10:00:00      249.4
        26 Remote         26     123456 XYZ            01-MAR-2016 10:15:00      247.8
        26 Remote         26     123456 XYZ            01-MAR-2016 10:30:00      248.4
        26 Remote         26     123456 XYZ            01-MAR-2016 10:45:00      247.8
        26 Remote         26     123456 XYZ            01-MAR-2016 11:00:00      247.6
        26 Remote         26     123456 XYZ            01-MAR-2016 11:15:00      247.6
        26 Remote         26     123456 XYZ            01-MAR-2016 11:30:00      247.1
        26 Remote         26     123456 XYZ            01-MAR-2016 11:45:00      247.1
        26 Remote         26     123456 XYZ            01-MAR-2016 12:00:00      246.3
        26 Remote         26     123456 XYZ            01-MAR-2016 12:15:00      245.8
        26 Remote         26     123456 XYZ            01-MAR-2016 12:30:00      245.6
        26 Remote         26     123456 XYZ            01-MAR-2016 12:45:00      245.4
        26 Remote         26     123456 XYZ            01-MAR-2016 13:00:00      245.7
        26 Remote         26     123456 XYZ            01-MAR-2016 13:15:00        245
        26 Remote         26     123456 XYZ            01-MAR-2016 13:30:00        245
        26 Remote         26     123456 XYZ            01-MAR-2016 13:45:00      244.8
        26 Remote         26     123456 XYZ            01-MAR-2016 14:00:00      245.4
        26 Remote         26     123456 XYZ            01-MAR-2016 14:15:00      245.3
        26 Remote         26     123456 XYZ            01-MAR-2016 14:30:00      245.3
        26 Remote         26     123456 XYZ            01-MAR-2016 14:45:00      245.6
        26 Remote         26     123456 XYZ            01-MAR-2016 15:00:00      245.3
        26 Remote         26     123456 XYZ            01-MAR-2016 15:15:00      245.2
        26 Remote         26     123456 XYZ            01-MAR-2016 15:30:00      244.8
        26 Remote         26     123456 XYZ            01-MAR-2016 15:45:00      245.1
        26 Remote         26     123456 XYZ            01-MAR-2016 16:00:00      244.6
        26 Remote         26     123456 XYZ            01-MAR-2016 16:15:00      244.8
        26 Remote         26     123456 XYZ            01-MAR-2016 16:30:00      244.6
        26 Remote         26     123456 XYZ            01-MAR-2016 16:45:00      244.3
        26 Remote         26     123456 XYZ            01-MAR-2016 17:00:00      244.3
        26 Remote         26     123456 XYZ            01-MAR-2016 17:15:00      244.9
        26 Remote         26     123456 XYZ            01-MAR-2016 17:30:00      244.9
        26 Remote         26     123456 XYZ            01-MAR-2016 17:45:00      244.7
        26 Remote         26     123456 XYZ            01-MAR-2016 18:00:00      244.5
        26 Remote         26     123456 XYZ            01-MAR-2016 18:15:00      244.6
        26 Remote         26     123456 XYZ            01-MAR-2016 18:30:00      244.6
        26 Remote         26     123456 XYZ            01-MAR-2016 18:45:00      244.8
        26 Remote         26     123456 XYZ            01-MAR-2016 19:00:00      245.4
        26 Remote         26     123456 XYZ            01-MAR-2016 19:15:00        245
        26 Remote         26     123456 XYZ            01-MAR-2016 19:30:00      245.1
        26 Remote         26     123456 XYZ            01-MAR-2016 19:45:00      245.2
        26 Remote         26     123456 XYZ            01-MAR-2016 20:00:00      245.2
        26 Remote         26     123456 XYZ            01-MAR-2016 20:15:00      245.5
        26 Remote         26     123456 XYZ            01-MAR-2016 20:30:00      245.7
        26 Remote         26     123456 XYZ            01-MAR-2016 20:45:00      245.8
        26 Remote         26     123456 XYZ            01-MAR-2016 21:00:00      245.8
        26 Remote         26     123456 XYZ            01-MAR-2016 21:15:00      245.6
        26 Remote         26     123456 XYZ            01-MAR-2016 21:30:00      245.9
        26 Remote         26     123456 XYZ            01-MAR-2016 21:45:00      245.4
        26 Remote         26     123456 XYZ            01-MAR-2016 22:00:00      245.2
        26 Remote         26     123456 XYZ            01-MAR-2016 22:15:00      245.4
        26 Remote         26     123456 XYZ            01-MAR-2016 22:30:00      245.6
        26 Remote         26     123456 XYZ            01-MAR-2016 22:45:00      245.4
        26 Remote         26     123456 XYZ            01-MAR-2016 23:00:00        245
        26 Remote         26     123456 XYZ            01-MAR-2016 23:15:00      244.5
        26 Remote         26     123456 XYZ            01-MAR-2016 23:30:00      244.9
        26 Remote         26     123456 XYZ            01-MAR-2016 23:45:00      244.8
        26 Remote         26     123456 XYZ            02-MAR-2016 00:00:00      244.4
        26 Remote         26     123456 XYZ            02-MAR-2016 00:15:00      245.1
        26 Remote         26     123456 XYZ            02-MAR-2016 00:30:00      244.9
        26 Remote         26     123456 XYZ            02-MAR-2016 00:45:00      244.9
        26 Remote         26     123456 XYZ            02-MAR-2016 01:00:00      244.8
        26 Remote         26     123456 XYZ            02-MAR-2016 01:15:00      245.2
        26 Remote         26     123456 XYZ            02-MAR-2016 01:30:00      244.8
        26 Remote         26     123456 XYZ            02-MAR-2016 01:45:00      245.1
        26 Remote         26     123456 XYZ            02-MAR-2016 02:00:00      244.9
        26 Remote         26     123456 XYZ            02-MAR-2016 02:15:00      245.6
        26 Remote         26     123456 XYZ            02-MAR-2016 02:30:00      245.6
        26 Remote         26     123456 XYZ            02-MAR-2016 02:45:00      245.8
        26 Remote         26     123456 XYZ            02-MAR-2016 03:00:00      245.7
        26 Remote         26     123456 XYZ            02-MAR-2016 03:15:00      245.8
        26 Remote         26     123456 XYZ            02-MAR-2016 03:30:00      245.9
        26 Remote         26     123456 XYZ            02-MAR-2016 03:45:00      246.5
        26 Remote         26     123456 XYZ            02-MAR-2016 04:00:00      246.5
        26 Remote         26     123456 XYZ            02-MAR-2016 04:15:00      247.1
        26 Remote         26     123456 XYZ            02-MAR-2016 04:30:00      247.4
        26 Remote         26     123456 XYZ            02-MAR-2016 04:45:00      247.1
        26 Remote         26     123456 XYZ            02-MAR-2016 05:00:00      247.3
        26 Remote         26     123456 XYZ            02-MAR-2016 05:15:00      247.1
        26 Remote         26     123456 XYZ            02-MAR-2016 05:30:00        247
        26 Remote         26     123456 XYZ            02-MAR-2016 05:45:00      248.1
        26 Remote         26     123456 XYZ            02-MAR-2016 06:00:00      247.5
        26 Remote         26     123456 XYZ            02-MAR-2016 06:15:00      248.2
        26 Remote         26     123456 XYZ            02-MAR-2016 06:30:00      248.2
        26 Remote         26     123456 XYZ            02-MAR-2016 06:45:00        248
        26 Remote         26     123456 XYZ            02-MAR-2016 07:00:00      247.9
        26 Remote         26     123456 XYZ            02-MAR-2016 07:15:00      247.8
        26 Remote         26     123456 XYZ            02-MAR-2016 07:30:00        248
        26 Remote         26     123456 XYZ            02-MAR-2016 07:45:00      247.9
        26 Remote         26     123456 XYZ            02-MAR-2016 08:00:00      247.9
        26 Remote         26     123456 XYZ            02-MAR-2016 08:15:00      248.1
        26 Remote         26     123456 XYZ            02-MAR-2016 08:30:00        248
        26 Remote         26     123456 XYZ1           01-MAR-2016 08:45:00      247.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 09:00:00      248.2
        26 Remote         26     123456 XYZ1           01-MAR-2016 09:15:00      246.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 09:30:00      248.5
        26 Remote         26     123456 XYZ1           01-MAR-2016 09:45:00      247.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 10:00:00      247.3
        26 Remote         26     123456 XYZ1           01-MAR-2016 10:15:00      245.3
        26 Remote         26     123456 XYZ1           01-MAR-2016 10:30:00      245.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 10:45:00      246.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 11:00:00      246.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 11:15:00      246.6
        26 Remote         26     123456 XYZ1           01-MAR-2016 11:30:00      244.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 11:45:00      244.8
        26 Remote         26     123456 XYZ1           01-MAR-2016 12:00:00      244.5
        26 Remote         26     123456 XYZ1           01-MAR-2016 12:15:00      244.6
        26 Remote         26     123456 XYZ1           01-MAR-2016 12:30:00      242.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 12:45:00      244.3
        26 Remote         26     123456 XYZ1           01-MAR-2016 13:00:00      244.2
        26 Remote         26     123456 XYZ1           01-MAR-2016 13:15:00        243
        26 Remote         26     123456 XYZ1           01-MAR-2016 13:30:00      243.6
        26 Remote         26     123456 XYZ1           01-MAR-2016 13:45:00      242.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 14:00:00      244.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 14:15:00      242.3
        26 Remote         26     123456 XYZ1           01-MAR-2016 14:30:00      243.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 14:45:00        243
        26 Remote         26     123456 XYZ1           01-MAR-2016 15:00:00      244.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 15:15:00      243.2
        26 Remote         26     123456 XYZ1           01-MAR-2016 15:30:00      242.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 15:45:00        243
        26 Remote         26     123456 XYZ1           01-MAR-2016 16:00:00      243.2
        26 Remote         26     123456 XYZ1           01-MAR-2016 16:15:00      242.5
        26 Remote         26     123456 XYZ1           01-MAR-2016 16:30:00      243.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 16:45:00      242.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 17:00:00      241.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 17:15:00      243.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 17:30:00      242.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 17:45:00      241.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 18:00:00      243.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 18:15:00      242.3
        26 Remote         26     123456 XYZ1           01-MAR-2016 18:30:00      241.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 18:45:00      242.6
        26 Remote         26     123456 XYZ1           01-MAR-2016 19:00:00      243.2
        26 Remote         26     123456 XYZ1           01-MAR-2016 19:15:00      243.8
        26 Remote         26     123456 XYZ1           01-MAR-2016 19:30:00      242.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 19:45:00      243.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 20:00:00      242.9
        26 Remote         26     123456 XYZ1           01-MAR-2016 20:15:00      243.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 20:30:00      243.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 20:45:00      243.3
        26 Remote         26     123456 XYZ1           01-MAR-2016 21:00:00      244.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 21:15:00      243.4
        26 Remote         26     123456 XYZ1           01-MAR-2016 21:30:00        244
        26 Remote         26     123456 XYZ1           01-MAR-2016 21:45:00      244.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 22:00:00      242.8
        26 Remote         26     123456 XYZ1           01-MAR-2016 22:15:00      243.1
        26 Remote         26     123456 XYZ1           01-MAR-2016 22:30:00        244
        26 Remote         26     123456 XYZ1           01-MAR-2016 22:45:00      242.8
        26 Remote         26     123456 XYZ1           01-MAR-2016 23:00:00      242.6
        26 Remote         26     123456 XYZ1           01-MAR-2016 23:15:00        243
        26 Remote         26     123456 XYZ1           01-MAR-2016 23:30:00      242.7
        26 Remote         26     123456 XYZ1           01-MAR-2016 23:45:00        242
        26 Remote         26     123456 XYZ1           02-MAR-2016 00:00:00      243.4
        26 Remote         26     123456 XYZ1           02-MAR-2016 00:15:00        243
        26 Remote         26     123456 XYZ1           02-MAR-2016 00:30:00      243.6
        26 Remote         26     123456 XYZ1           02-MAR-2016 00:45:00      242.4
        26 Remote         26     123456 XYZ1           02-MAR-2016 01:00:00      243.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 01:15:00      243.1
        26 Remote         26     123456 XYZ1           02-MAR-2016 01:30:00      243.7
        26 Remote         26     123456 XYZ1           02-MAR-2016 01:45:00      243.1
        26 Remote         26     123456 XYZ1           02-MAR-2016 02:00:00      243.9
        26 Remote         26     123456 XYZ1           02-MAR-2016 02:15:00        243
        26 Remote         26     123456 XYZ1           02-MAR-2016 02:30:00      243.7
        26 Remote         26     123456 XYZ1           02-MAR-2016 02:45:00      244.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 03:00:00      243.4
        26 Remote         26     123456 XYZ1           02-MAR-2016 03:15:00      244.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 03:30:00      243.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 03:45:00      245.2
        26 Remote         26     123456 XYZ1           02-MAR-2016 04:00:00      245.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 04:15:00      244.7
        26 Remote         26     123456 XYZ1           02-MAR-2016 04:30:00      245.5
        26 Remote         26     123456 XYZ1           02-MAR-2016 04:45:00      245.1
        26 Remote         26     123456 XYZ1           02-MAR-2016 05:00:00      246.5
        26 Remote         26     123456 XYZ1           02-MAR-2016 05:15:00      245.9
        26 Remote         26     123456 XYZ1           02-MAR-2016 05:30:00      245.3
        26 Remote         26     123456 XYZ1           02-MAR-2016 05:45:00      246.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 06:00:00      246.6
        26 Remote         26     123456 XYZ1           02-MAR-2016 06:15:00        246
        26 Remote         26     123456 XYZ1           02-MAR-2016 06:30:00      246.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 06:45:00      247.2
        26 Remote         26     123456 XYZ1           02-MAR-2016 07:00:00      245.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 07:15:00      246.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 07:30:00      247.3
        26 Remote         26     123456 XYZ1           02-MAR-2016 07:45:00      245.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 08:00:00      245.8
        26 Remote         26     123456 XYZ1           02-MAR-2016 08:15:00      246.9
        26 Remote         26     123456 XYZ1           02-MAR-2016 08:30:00      246.9

384 rows selected.



Re: Need to insert data from XML file into Oracle Table (very urgent) [message #651824 is a reply to message #651820] Wed, 25 May 2016 15:01 Go to previous message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
It is working perfect for my situation now. I can able to add/delete the required columns and even the required tags as well..
Now i have to deal the same for very huge file, which is also in the same format.
Thanks a lot for your wonderful support.
Previous Topic: Using XML to insert into a table with self-reference
Next Topic: FOR ORDINALITY Read order
Goto Forum:
  


Current Time: Mon Nov 20 09:26:29 CST 2017

Total time taken to generate the page: 0.01698 seconds