Re: Can I do this strictly in SQL*Plus?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 06 Jun 2005 21:15:53 +0200
Message-ID: <3789a1d7vhkon4f5fbcn6fd26ivvenja3s@4ax.com>

On 6 Jun 2005 12:08:18 -0700, "RK" <rekaben_at_yahoo.com> wrote:

>Can someone help me, please? -- I want to do the following steps, and
>output strictly in SQL*Plus only:
>
>-1- select count(*) from table1;
>-2- select count(*) from table2;
>
>Assume the results are r1 and r2, two numbers, and I want the output to
>be like:
>
>Total: r1 + r2
>Count1: r1
>Count2: r2
>
>Can I do this strictly in SQL*Plus?
>
>Thanks.

Yes

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Jun 06 2005 - 14:15:53 CDT