SQL*Plus (MOSC)

MOSC Banner

Unable to get SKIP to work with SQL*Plus using HTML

edited Jul 25, 2019 11:29AM in SQL*Plus (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center