Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can I do this strictly in SQL*Plus?

Can I do this strictly in SQL*Plus?

From: RK <rekaben_at_yahoo.com>
Date: 6 Jun 2005 12:08:18 -0700
Message-ID: <1118084898.857999.85230@g49g2000cwa.googlegroups.com> 





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.
Received on Mon Jun 06 2005 - 14:08:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US