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, 2389🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...