Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Generate Query Output in HTML Format
How To Generate Query Output in HTML Format? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool
✍: FYIcenter.com
If you want your query output to be generated in HTML format, you can use the "SET MARKUP HTML ON" to turn on the HTML feature. The following tutorial exercise gives you a good example:
SQL> connect HR/retneciyf SQL> SET MARKUP HTML ON SQL> SELECT FIRST_NAME, LAST_NAME, HIRE_DATE <br> 2 FROM EMPLOYEES WHERE FIRST_NAME LIKE 'Joh%'; <br> <p> <table border='1' width='90%' align='center' summary='Script output'> <tr> <th scope="col"> FIRST_NAME </th> <th scope="col"> LAST_NAME </th> <th scope="col"> HIRE_DATE </th> </tr> <tr> <td> John </td> <td> Seo </td> <td> 12-FEB-98 </td> </tr> <tr> <td> John </td> <td> Russell </td> <td> 01-OCT-96 </td> </tr> </table> <p>
2007-04-29, 4957👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - Can we use events with threading ? Yes, you can use events with thread; t...
How To Get the Uploaded File Information in the Receiving PHP Script? Once the Web server received t...
What's the difference between J2SDK 1.5 and J2SDK 5.0? There is no difference, Sun Microsystems just...
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...
How do I use a scriptlet to initialize a newly instantiated bean? A jsp:useBean action may optionall...