今天在看ITPUB论坛上的帖子,需要把oracle的表数据转换成XML文件。
采用DBMS_XMLGEN包可以解决此问题。
SQL> create table test_xml(id number,name varchar2(20));
Table created
SQL> insert into test_xml values(1,'blue'); 1 row inserted SQL> commit; Commit complete SQL> select * from test_xml; ID NAME ---------- -------------------- 1 blue SQL> select dbms_xmlgen.getxml('select * from test_xml') from dual; DBMS_XMLGEN.GETXML('SELECT*FRO -------------------------------------------------------------------------------- <?xml version="1.0"?> 1 blue select dbms_xmlgen.getxml('select * from test_xml') xml from dual; XML -------------------------------------------------------------------------------- <?xml version="1.0"?> 1 blue