Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
  • ORACLE_SID in sqlplus Oracle
  • Find_table_size.sql Oracle
  • Good notes for shared pool Oracle
  • Jai Shree Ram Oracle
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Jai Shree Ram Oracle
  • Good links for x$ tables in oracle. Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Display the top 5 salaries for each department using single SQL Oracle
  • cur_sql.sql Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix
  • compile_inv.sql Oracle

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
  • dbinv.sql Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Rman Notes -1 Oracle
  • create a folder in multiple places Linux/Unix
  • Error Handling in Proc Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • Oracle Identifiers Oracle
  • cif crons Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme