Home » SQL & PL/SQL » Client Tools » qry o/p (oracle 9i)
qry o/p [message #490321] Mon, 24 January 2011 00:22 Go to next message
vivek_rol
Messages: 65
Registered: February 2009
Member


is it possible to write select query o/p in html tag?
Re: qry o/p [message #490322 is a reply to message #490321] Mon, 24 January 2011 00:24 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
>is it possible to write select query o/p in html tag?
yes
Re: qry o/p [message #490323 is a reply to message #490322] Mon, 24 January 2011 00:24 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Use
set markup html on
run your query

sriram
Re: qry o/p [message #490324 is a reply to message #490322] Mon, 24 January 2011 00:25 Go to previous messageGo to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
will u please describe?
Re: qry o/p [message #490325 is a reply to message #490324] Mon, 24 January 2011 00:41 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ind> set markup html on
ind> 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
Re: qry o/p [message #490326 is a reply to message #490324] Mon, 24 January 2011 01:02 Go to previous messageGo to next message
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
Re: qry o/p [message #490328 is a reply to message #490326] Mon, 24 January 2011 01:10 Go to previous message
Michel Cadot
Messages: 65848
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
Previous Topic: command line tools
Next Topic: Toad is getting hang ....
Goto Forum:
  


Current Time: Sat Oct 20 23:05:54 CDT 2018