Re: question regarding xml

steve750813_at_yahoo.com (steverourke) wrote i

> i am very newbie on oracle dbms; i know nothing but some sql
> techniques as far as database. i have a question redarding xml
> theoretically, it should be possible that whatever i put into database
> can be converted to xml, then that xml can be transfered via internet
> to the other part that want to have data - i do know wheter it is
> possible or not.
> am i imagining too much?
> if possible, what would be a way to do so, what techniques?

What is XML? Nothing but a data block. It is no different than any other block of data ito of how you put that block into a database, transfer it to another database, submit it via a POST/PUT/GET to a web server, etc. etc.

So don't treat XML any differently that you would any other block of data in that regard.

What you _do_ with the block is of course another matter - XML allows an intelligent data structure within that block. But that has nothing to do with how the block is "managed" from a database storage/retrieval perspective, or how it is FTP'ed from one server to another, etc.

As for Oracle - it supports XML. You can store it. You can parse it. And do all kinds of interingting kinky & froody things with it. http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage#index-XML

--
Billy