OraFAQ Forum: Client Tools

Home » Other » Client Tools » qry o/p (oracle 9i)

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

qry o/p [message #490321]

Mon, 24 January 2011 00:22

vivek_rol
Messages: 65
Registered: February 2009

Member

is it possible to write select query o/p in html tag?

Report message to a moderator

Re: qry o/p [message #490322 is a reply to message #490321]

Mon, 24 January 2011 00:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is it possible to write select query o/p in html tag?
yes

Report message to a moderator

Re: qry o/p [message #490323 is a reply to message #490322]

Mon, 24 January 2011 00:24

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Use
set markup html on
run your query

sriram

Report message to a moderator

Re: qry o/p [message #490324 is a reply to message #490322]

Mon, 24 January 2011 00:25

vivek_rol
Messages: 65
Registered: February 2009

Member

will u please describe?

Report message to a moderator

Re: qry o/p [message #490325 is a reply to message #490324]

Mon, 24 January 2011 00:41

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ind> set markup html on
ind&gt; select sysdate from dual;
<br>
<p>
<table border='1' width='90%' align='center' summary='Script output'>
<tr>
<th scope="col">
SYSDATE
</th>
</tr>
<tr>
<td>
24-JAN-11
</td>
</tr>
</table>
<p>

1 row selected.<br>
<br>


ind&gt; set markup html off
<br>
ind>

sriram

Report message to a moderator

Re: qry o/p [message #490326 is a reply to message #490324]

Mon, 24 January 2011 01:02

vivek_rol
Messages: 65
Registered: February 2009

Member

below is my html code

<html>
<head>
<title>Tables</title>
</head>
<body>
<table>
<tr>
<td> empno </td>
<td> ename </td>
<td> sal </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html>

whnehere i fire any qry for specific emp its three column must be populate in
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
in above html code

Report message to a moderator

Re: qry o/p [message #490328 is a reply to message #490326]

Mon, 24 January 2011 01:10

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read the followings and come back with your tries(and a more precise question) if you don't succeed:
Generating HTML Reports from SQL*Plus
Enabling User Defined HTML Markup
SET MARK[UP] HTML

Regards
Michel

Report message to a moderator

Previous Topic:	command line tools
Next Topic:	Toad is getting hang ....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 19:57:51 CDT 2024