WEBROWSET

import java.io.FileOutputStream;
import oracle.jdbc.rowset.OracleWebRowSet;
public class Test38 {
public static void main(String[] args) throws Exception {
OracleWebRowSet oc = new OracleWebRowSet();
oc.setUrl("jdbc:oracle:thin:@localhost:1521:orcl");
oc.setUsername("scott");
oc.setPassword("rakesh");
oc.setCommand("select empno,ename,sal from emp");
oc.execute();
FileOutputStream fos = new FileOutputStream("emp.xml");
oc.writeXml(fos);
}
}

Output - 
emp.xml

<?xml version="1.0" encoding="UTF-8"?>
<webRowSet xmlns="http://java.sun.com/xml/ns/jdbc"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://java.sun.com/xml/ns/jdbc http://java.sun.com/xml/ns/jdbc/webrowset.xsd">
  <properties>
    <command>select empno,ename,sal from emp</command>
    <concurrency>1007</concurrency>
    <datasource></datasource>
    <escape-processing>true</escape-processing>
    <fetch-direction>1002</fetch-direction>
    <fetch-size>10</fetch-size>
    <isolation-level>2</isolation-level>
    <key-columns>
    </key-columns>
    <map>
    </map>
    <max-field-size>0</max-field-size>
    <max-rows>0</max-rows>
    <query-timeout>0</query-timeout>
    <read-only>false</read-only>
    <rowset-type>1005</rowset-type>
    <show-deleted>false</show-deleted>
    <table-name></table-name>
    <url>jdbc:oracle:thin:@localhost:1521:orcl</url>
    <sync-provider>
      <sync-provider-name>com.sun.rowset.providers.RIOptimisticProvider</sync-provider-name>
      <sync-provider-vendor>Oracle Corporation</sync-provider-vendor>
      <sync-provider-version>1.0</sync-provider-version>
      <sync-provider-grade>2</sync-provider-grade>
      <data-source-lock>1</data-source-lock>
    </sync-provider>
  </properties>
  <metadata>
    <column-count>3</column-count>
    <column-definition>
      <column-index>1</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>false</case-sensitive>
      <currency>true</currency>
      <nullable>0</nullable>
      <signed>true</signed>
      <searchable>true</searchable>
      <column-display-size>22</column-display-size>
      <column-label>EMPNO</column-label>
      <column-name>EMPNO</column-name>
      <schema-name></schema-name>
      <column-precision>4</column-precision>
      <column-scale>0</column-scale>
      <table-name></table-name>
      <catalog-name></catalog-name>
      <column-type>2</column-type>
      <column-type-name>NUMBER</column-type-name>
    </column-definition>
    <column-definition>
      <column-index>2</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>true</case-sensitive>
      <currency>false</currency>
      <nullable>1</nullable>
      <signed>true</signed>
      <searchable>true</searchable>
      <column-display-size>10</column-display-size>
      <column-label>ENAME</column-label>
      <column-name>ENAME</column-name>
      <schema-name></schema-name>
      <column-precision>0</column-precision>
      <column-scale>0</column-scale>
      <table-name></table-name>
      <catalog-name></catalog-name>
      <column-type>12</column-type>
      <column-type-name>VARCHAR2</column-type-name>
    </column-definition>
    <column-definition>
      <column-index>3</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>false</case-sensitive>
      <currency>true</currency>
      <nullable>1</nullable>
      <signed>true</signed>
      <searchable>true</searchable>
      <column-display-size>22</column-display-size>
      <column-label>SAL</column-label>
      <column-name>SAL</column-name>
      <schema-name></schema-name>
      <column-precision>7</column-precision>
      <column-scale>2</column-scale>
      <table-name></table-name>
      <catalog-name></catalog-name>
      <column-type>2</column-type>
      <column-type-name>NUMBER</column-type-name>
    </column-definition>
  </metadata>
  <data>
    <currentRow>
      <columnValue>7369</columnValue>
      <columnValue>SMITH</columnValue>
      <columnValue>1600</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7499</columnValue>
      <columnValue>ALLEN</columnValue>
      <columnValue>2100</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7521</columnValue>
      <columnValue>WARD</columnValue>
      <columnValue>1750</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7566</columnValue>
      <columnValue>JONES</columnValue>
      <columnValue>3675</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7654</columnValue>
      <columnValue>MARTIN</columnValue>
      <columnValue>1750</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7698</columnValue>
      <columnValue>BLAKE</columnValue>
      <columnValue>3350</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7782</columnValue>
      <columnValue>CLARK</columnValue>
      <columnValue>2950</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7788</columnValue>
      <columnValue>SCOTT</columnValue>
      <columnValue>3700</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7839</columnValue>
      <columnValue>KING</columnValue>
      <columnValue>5500</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7844</columnValue>
      <columnValue>TURNER</columnValue>
      <columnValue>2000</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7876</columnValue>
      <columnValue>ADAMS</columnValue>
      <columnValue>1800</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7900</columnValue>
      <columnValue>JAMES</columnValue>
      <columnValue>1450</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7902</columnValue>
      <columnValue>FORD</columnValue>
      <columnValue>3700</columnValue>
    </currentRow>
    <currentRow>
      <columnValue>7934</columnValue>
      <columnValue>MILLER</columnValue>
      <columnValue>1800</columnValue>
    </currentRow>
  </data>

</webRowSet>