Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • SQL Server: How to see current transactions or requests SQL Server
  • Renaming the column name Oracle
  • find_err.sql for finding errors from dba_errors. Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • alter database backup controlfile to trace Oracle
  • switchlogfile.sh Linux/Unix
  • Library cahe Latches and internal explaination Oracle
  • Oracle 11g Training on 29JAN1010 Oracle
  • plan10g.sql good1 Oracle
  • PLSQL Table Syntax 2 Oracle
  • Very Good Oralce Internal Tuning Book Oracle
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • checking connectivity between two servers Linux/Unix
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix

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

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • perf_today.sql Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • catall.sh Linux/Unix
  • Session_info.ksh Linux/Unix
  • send email from unix mailx with attachment. Linux/Unix
  • Remove duplicate rows from table Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme