Hey Yin,
Glad that you have posted this question. After this long years I have the same question. I want to extract the xml content from xml_doc column. SDE has a function sdexmltotext but I would like to understand how to construct xml using DB functions or BLOB operations.
Did you find any solution for this? Appreciate your time on this.
Thanks.
Arun Raj
Do any of the pages in these legacy 9.3 docs help?
Does SDE.GDB_ITEMS_VW help you at all?
Also, looking at the SQL definition of that view might be of interest.