Re: XML file from oracle tables

Kalle wrote:

> Hi all,
>
> I am a newbie concerning xml and I have asked to generate an xml file by
> querying some tables...
>
> How this could be done, any ideas, is it difficult, I hope you have some
> examples...
>
> Thank you again,
>
> Kalle

Kalle,

Oracle's technology site, http://otn.oracle.com, has a number of interesting areas:

1. In Services, under Training, they have 'Oracle by Example', which is a set of tutorials with screen shots. Check Oracle9i Release 2 under Content Management.
2. In Services, under Sample Code in the XML section, they have a number (at least 15) of working examples of using XML with Oracle. At least one of these should help.
3. In Technology Centers, under XML, there are discussions including examples.
4. In Services, under Documentation, (also http://docs.oracle.com) you will find access to the documentation. Check out the XML documents in the Database and the APplication Server sections.

In addition, O'Reilly's older book 'Building Oracle XML Applications' by Steven Muensch is a tutorial which includes installing an older version of JDeveloper and building a whole XML-based appication. There are also a few good books in Osborne and Oracle Press.

Hopefully the above links will help.

/Hans Received on Fri Nov 19 2004 - 05:40:31 CST