Well, well, well!
It's Irfan! How are you? Where have you been? hehe. Check out code below.


SET ECHO OFF
SET TERMOUT OFF
SET LONG 1000
SET LINES 2000
SET MARKUP HTML ON SPOOL ON
SPOOL CLOB2.html
SELECT ID_COURSE, ID_REQUEST, DS_OBJECTIVES
FROM SCNS_DATA.T_SCNS_COURSE_REQUEST
WHERE ID_COURSE = 3381;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON
--EXIT





-----Original Message-----
From: Irfan Rehman
[mailto:oracledba-ezmlmshield-x26188090.[Email address protected]
Sent: Thursday, March 02, 2006 12:51 AM
To: LazyDBA Discussion
Subject: convert SQL to HTML


Can anyone know how to convert SQL statements result to HTML, I heard
its possible through oracle package but I search and didn't find any
package.







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

Oracle LazyDBA home page