Ordering Output of a select

[Yogeeraj_1]

hi again,

You can also try using the Oracle XML
Developer's Kits (XDK's).

With the XDK, you can generate XML from SQL queries using PL/SQL, Java, C or C++. The following command on the command line generates an XML document containing the first 4 rows of the SCOTT.EMP table:
$ java OracleXML getXML -user "scott/tiger" "select * from emp where rownum < 5"
> emp.xml

hope this helps too!

kind regards
yogeeraj

[Arturo Galbiati]

Hi,
try this:
set pages 0 trims on tab off lines 80 feed off

take care to set correctly the linesize (i put as default 80)

HTH,
Art