Home » Other » Client Tools » Formating output of a query in html ?
icon5.gif  Formating output of a query in html ? [message #278823] Mon, 05 November 2007 16:01 Go to next message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Hello, I need a query sql I return the result in html; What we need is for example:

create table test(
c1 varchar(10),
c2 varchar(10),
n1 numeric);

select c1,c2,n1 from test;

Return:

c1 c2 n1
== == ==
AA BB 1
CC BB 2
DD AA 0

I need returned a table html of format:

<tr><td>c1</td><td>c2</td><td>n1</td></tr>
<tr><td>AA</td><td>BB</td><td>1</td></tr>
<tr><td>CC</td><td>BB</td><td>2</td></tr>
<tr><td>DD</td><td>AA</td><td>o</td></tr>


I hope I can help with this

Thanks

Re: Formating output of a query in html ? [message #278827 is a reply to message #278823] Mon, 05 November 2007 16:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> I need a query sql I return the result in html

Why do you post a question on basic SQL in the PL/SQL Expert forum?

SQL> SET MARKUP HTML ON

[Updated on: Mon, 05 November 2007 16:21] by Moderator

Report message to a moderator

Re: Formating output of a query in html ? [message #278828 is a reply to message #278827] Mon, 05 November 2007 16:29 Go to previous message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Thanks for responding, takes into account your comments
Previous Topic: SQL +
Next Topic: Suprime message Old and New SQLPlus
Goto Forum:
  


Current Time: Fri Mar 29 07:22:59 CDT 2024