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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Plus Reporting

Re: SQL Plus Reporting

From: Vjoshi2 <vjoshi2_at_aol.com>
Date: 3 Sep 1998 12:05:05 GMT
Message-ID: <1998090312050500.IAA15409@ladder03.news.aol.com> 





Hi,


You are nearly there.


In sqlplus you can declare variables that will HOLD values.
eg.


columnx new_value columnx.


select count(*) columnx from ...... where ....



And then you can refer to those values by using &
eg select &columnx from dual;


Received on Thu Sep 03 1998 - 07:05:05 CDT












Original text of this message













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