Hi

I am Kristipati Subramanyam, I think .. following example will satisfy your needs

--===============================================================

-- Let's say the following XML document is saved as c:\books.xml:

--===============================================================

<?xml version="1.0"?>

<Books>

      <Book>

            <Title>XML Application Development with...

Hi ,

I am Kristipati Subramanyam, giving you an example..

-- =============================================

-- Create Table

-- =============================================

create table TestTbl100( a numeric)

-- =============================================

-- insert few records into TestTbl100

-- =============================================

insert into TestTbl100 values(5)

insert into TestTbl100 values(5)

insert...