您可以使用dbms_xmlgen.getxml()函数生成XML.有关详细信息,请参阅以下链接:
https://docs.oracle.com/cd/B10501_01/appdev.920/a96620/xdb12gen.htm#1025729
select dbms_xmlgen.getxml( 'select * from emp') as emp_xml from dual;
但是,要在磁盘上创建XML,您需要使用UTL包.例如.
DECLARE F UTL_FILE.FILE_TYPE; MYCLOB CLOB; BEGIN SELECT DBMS_XMLGEN.GETXML(' select deptno,dname,loc from emp ') INTO MYCLOB FROM DUAL; F := UTL_FILE.FOPEN(dest_path,'EMP.XML','w',32767); UTL_FILE.PUT(F,MYCLOB); UTL_FILE.FCLOSE(F); END;