Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I do this strictly in SQL*Plus?
Can you show me how you would do it?
Sybrand Bakker wrote:
> 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:37:36 CDT