Home » Developer & Programmer » JDeveloper, Java & XML » How to Generate Xml file and HTML from Oracle 9i
How to Generate Xml file and HTML from Oracle 9i [message #91540] Mon, 28 October 2002 04:40 Go to next message
Mgate
Messages: 1
Registered: October 2002
Junior Member
Pls inform me that How to Generate Xml file and HTML from Oracle 9i . if u have some detail plz email me
mgate@lycos.co.uk

thank in advance
Mgate

mgate@lycos.co.uk
Re: How to Generate Xml file and HTML from Oracle 9i [message #91541 is a reply to message #91540] Mon, 28 October 2002 07:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
checkout the file, c:report.html...
SQL> SET MARKUP HTML ON SPOOL ON BODY "TEXT='#FF00Ff'"
SQL> spool c:report.html
SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE                    SAL       COMM     DEPTNO
---------- ---------- --------- ---------- -------------------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 DEC 17 1980 00:00:00        300                    20
      7499 ALLEN      SALESMAN        7698 FEB 20 1981 00:00:00        300        300         30
      7521 WARD       SALESMAN        7698 FEB 22 1981 00:00:00        300        500         30
      7566 JONES      MANAGER         7839 APR 02 1981 00:00:00        300                    20
      7654 MARTIN     SALESMAN        7698 SEP 28 1981 00:00:00        300       1400         30
      7698 BLAKE      MANAGER         7839 MAY 01 1981 00:00:00        300                    30
      7782 CLARK      MANAGER         7839 JUN 09 1981 00:00:00        300                    10
      7788 SCOTT      ANALYST         7566 APR 19 1987 00:00:00        300                    20
      7839 KING       PRESIDENT            NOV 17 1981 00:00:00        300                    10
      7844 TURNER     SALESMAN        7698 SEP 08 1981 00:00:00        300          0         30
      7876 ADAMS      CLERK           7788 MAY 23 1987 00:00:00        300                    20
      7900 JAMES      CLERK           7698 DEC 03 1981 00:00:00        300                    30
      7902 FORD       ANALYST         7566 DEC 03 1981 00:00:00        300                    20
      7934 MILLER     CLERK           7782 JAN 23 1982 00:00:00        300                    10

14 rows selected.

SQL> spool off

Re: How to Generate Xml file and HTML from Oracle 9i [message #91547 is a reply to message #91540] Tue, 05 November 2002 08:14 Go to previous message
ddsf
Messages: 1
Registered: November 2002
Junior Member
sdfsd
Previous Topic: Application Error (jrew.exe)
Next Topic: Re: sample test questions for OCP exams IZO-501/502/504/505
Goto Forum:
  


Current Time: Wed Aug 04 13:52:03 CDT 2021