Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to know current SID Oracle
  • Find Stale DR Physical Standby Oracle
  • ext#.sql Oracle
  • Find nth max and min. Oracle
  • Rename Oracle Instance Name Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • JSON/XML Types in Oracle Oracle
  • find_err.sql for finding errors from dba_errors. Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • Alter procedure auditing Oracle
  • Query to Generate aggregate on every 30 mins. Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • eplan.sql Oracle
  • Proc code Oracle
  • Reading config file from other folder inside class Python/PySpark

Tag: Sqlplus

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
  • Parallel DML Oracle
  • plan10g.sql good Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • Oracle Data Direct to TAPE Oracle
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • Oracle Support Metalink ID 161818.1 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme