Unable to get SKIP to work with SQL*Plus using HTML
Hi
I have created a report on 11.2.0.4 on AIX using -M "HTML ON PREFORMAT ON" . The report is exactly as I want except it is not skipping 1 line after the database name changes (although it is breaking). I have been unable to figure out why. Any ideas?
Following is the query:
set echo off feedback off verify off linesize 200 pagesize 46
col name for a10
col Today new_value xToday noprint format a1 trunc
col jd.command_id for a25
col TIME_TAKEN_DISPLAY for a10
ttitle center 'Backup Report' skip 1 -
center 'Last 30 Days' skip 3
btitle left xToday -
right 'Page ' format 999 sql.pno