Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 5745👍, 0💬
Popular Posts:
What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...
Can JavaScript steal text from your clipboard? It is true, text you last copied for pasting (copy &a...
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wa...
How To Control Horizontal Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By...