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, 2410🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...