Re: Oracle XML format

SQL wrote:
> Hi,
>
> I need help in writing an xml file, that contains a record to a table,
> which can be read through a oracle database.
>
> For example,
> if you pass a record value as a text message through a XML file the
> Oracle database should add the field values to the tables.
> Record can be -

This is a strange XML format!

> 1|22|237|'weeeee'|'K_P|'DAY'|TO_Date('05/02/2001 01:53:18
> PM','MM/DD/YYYY HH:MI:SS AM')|NULL|TEST
>
> Oracle should be able delimiter the string by "|" (or any other) and
> insert the values to the correct table.

It can. See the Oracle docs under SQL*Plus; the 'set' command'

>
> To accommodate this problem, how can the format of the XML file be?
> What should it contain?

The normal XML stuff (like correctly formatted tags, etc.).

>
> Thanks

--
Ron Reidy
Oracle DBA