Oracle查询结果 存储为XML？
在sqlserver 中可以把查询的表结构以xml输出，但oracle怎么写啊
sqlserver:
select ID,Name from A for xml raw
Oracle:
???
select ID,Name from A where User='cccc' for xml raw
该如何写啊 select dbms_xmlquery.getXML('select * from billhead where rownum <2') from dual;
DBMS_XMLQUERY.GETXML('SELECT*F
--------------------------------------------------------------------------------
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<IBILLHEADID>3434</IBILLHEADID>
<CBILLNAME>收付-497</CBILLNAME>
<CLASS1ID>2</CLASS1ID>
<CLASS2ID>21</CLASS2ID>
<CLASS3ID>92</CLASS3ID>
<CLASS4ID>0</CLASS4ID>
<CLASS5ID>0</CLASS5ID>
<CLASS6ID>0</CLASS6ID>
<CLASS7ID>4093</CLASS7ID>
<CLASS8ID>0</CLASS8ID>
<DBILLDATE>1/28/2005 0:0:0</DBILLDATE>
<IORGID>185</IORGID>
<CUSERID>1536</CUSERID>
<STATUS>10</STATUS>
<CPAIDTYPE>1</CPAIDTYPE>
<IBILL>840</IBILL>
<IREALBILL>840</IREALBILL>
<IPROCESSINSTID>0</IPROCESSINSTID>
<MEMO>报销14893车维修费</MEMO>
<CBILLTYPE>1</CBILLTYPE>
<IBILLYEAR>2005</IBILLYEAR>
<IRESULT>1</IRESULT>
<IISJZ>0</IISJZ>
<IMYORGID>185</IMYORGID>
<ICUTBD>0</ICUTBD>
<IUSEPC>0</IUSEPC>
</ROW>
</ROWSET>
页:
[1]