急啊,谁能帮帮我,XML解析问题.

Question

oracle中的xml解析
在oracle中,如何解析下面的XML语句
<Root>
          <Berth>
                 <Code>abc</Code>
                 <Name>abc123</Name>
          </Berth>
          <Berth>
                 <Code>def</Code>
                 <Name>def123</Name>
          </Berth>
    </Root>目的:解析成2行表格形式的
Code     Name
abc        abc123
def         def123
解析成表格形式,谢谢了!!

Answer 1

http://www.oracle.com/technology/global/cn/sample_code/tutorials/parser/parsertoc.htm

Answer 2

赫赫，你想在XMLdb下面解析，还是想解析这段文字？