------------------------------------------------------------------------------
--
-- Akadia Create XML docs
--
-- (c) Akadia AG 2002
--
-- Requires Oracle 8i or 9i
--
-- Create XML docs using XMLGEN package.
--
------------------------------------------------------------------------------
CONNECT scott/tiger@sid
--
SELECT xmlgen.getXml(
  'SELECT empno "EMP_NO"
        , ename "NAME"
        , deptno "DEPT_NO"
     FROM emp
    WHERE deptno = 10'
  , 0
  ) FROM dual;