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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 06 Jun 2005 22:37:45 +0200
Message-ID: <d82c6e$oec$05$1@news.t-online.com>

RK schrieb:
> 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.
>

There are many ways,
for example
SQL> select sum(cnt),nvl(tname,'total')

2 from (select count(*) cnt,'user_tables' tname from user_tables 3 union all select count(*) cnt,'user_indexes' tname from user_indexes) 4 group by rollup(tname)
5 /

SUM(CNT) NVL(TNAME,'TOTAL')

---------- ------------------------------------
        348 user_indexes
        344 user_tables
        692 total

SQL> Best regards

Maxim Received on Mon Jun 06 2005 - 15:37:45 CDT