Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • How to find password change date for user Oracle
  • Find long Running Transaction Linux/Unix
  • SQL_PROFILE – I explaination Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • The most important Tuning Notes Oracle
  • setting prompt display with .profile Linux/Unix
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • Facts about SCN and Rollback Segment Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • find_open_cur.sql Find open cursorts per session Oracle
  • cp_filesystem.sql Oracle
  • Roles and Stored Object behaviour Oracle

Tag: sql*plus

Sending SQLPLUS output in HTML format

Posted on 17-Feb-201025-May-2023 By Admin No Comments on Sending SQLPLUS output in HTML format

SET MARKUP HTML ON SPOOL ON generates an HTML page for each subsequently spooled file. The HTML tags in a spool file are closed when SPOOL OFF is executed or SQL*Plus exits. You can use SET MARKUP HTML ON SPOOL OFF to generate HTML output suitable for embedding in an existing web page. HTML output…

Read More “Sending SQLPLUS output in HTML format” »

Oracle, SQL scripts

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • handling filenname with space Linux/Unix
  • All About oracle password and security from metalink Oracle
  • Temporary Tablespsace Temp tablespace behaviour Oracle
  • v$backup.status information Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • get_aix_vmstat.ksh Oracle
  • Database logon trigger issue Oracle
  • SYSOPER Mystery Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme