OraFAQ Forum: Client Tools » Formating output of a query in html ?

Home » Other » Client Tools » Formating output of a query in html ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Formating output of a query in html ? [message #278823]

Mon, 05 November 2007 16:01

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

Report message to a moderator