Shulou(Shulou.com)06/01 Report--

From oracle to xml

1. Start sqlplus execution >

The TABLE_NAME,OWNER in the replacement statement is the name and user name of the table to be exported. The modified statement is executed in sqlplus (dba permission is required for the user to execute the statement).

SELECT replace (wm_concat (cols),'| |') FROM (SELECT''SCOTT' | |''| |'| | column_name | |'| |''AS cols FROM DBA_COL_COMMENTS WHERE TABLE_NAME = 'DEPT'AND owner=' SCOTT')

two。 Create a new script xml.sql file with the following content:

Replace the content from the following statement to |''with the execution result in step 1, change SCOTT.DEPT to the user name and table name in step 1, and execute this statement in sqlplus after modification

Set colsep, set feedback off set heading off set trimout on spool / home/oracle/dept.xml SELECT''| | replace (wm_concat (dept_info),'') | | 'FROM (SELECT''| | ROWNUM | |'| |'| DEPTNO |'| | DNAME |'| | LOC | |'| |'AS dept_infoFROM SCOTT.DEPT); spool off exit |

Note:

Spool / home/oracle/dept.xml-specify the path and file name of the exported xml file (modifiable)

The select statement specifies the export table and fields

3.

Sqlplus-s username / password @ database name @ / path / xml_auto.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.