Re: Q:Report w SQL Plus

From: Arjan van Bentem <avbentem_at_DONT-YOU-DARE-cable.a2000.nl>
Date: 1998/07/17
Message-ID: <6omlem$p90$1@newton.a2000.nl>#1/1

What about using an extra last line? Add

    prompt End of report

after you real query. Or, before your query add

    set feedback off

to surpress the normal row count and after your real query, add something like:

    variable LastLine char
    begin

        if sql%rowcount = 0 then


            :LastLine := 'No data found.';

        else


            :LastLine := to_char( sql%rowcount ) || ' records found';

        end if;

    end;
    prompt &LastLine

Arjan. Received on Fri Jul 17 1998 - 00:00:00 CDT