Collections:
Generate Query Output in HTML Format in Oracle
How To Generate Query Output in HTML Format in Oracle?
✍: 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>
⇒ Output Spooling in SQL*Plus in Oracle
⇐ SQL*Plus Environment Variables in Oracle
2020-07-15, 1801👍, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple t...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...