Generating XML from SQLPLUS

set pages 0

set linesize 150

set long 9999999

set head off

SQL> select dbms_xmlgen.getxml(‘select employee_id, first_name,

2 last_name, phone_number from employees where rownum < 6') xml
3 from dual

100

Steven

King

515.123.4567





101

Neena

Kochhar

515.123.4568





102

Lex

De Haan

515.123.4569





103

Alexander

Hunold

590.423.4567





104

Bruce

Ernst

590.423.4568