SQL Plus Reporting

From: <vishmok_at_my-dejanews.com>
Date: Tue, 01 Sep 1998 22:02:06 GMT
Message-ID: <6shqst$gge$1@nnrp1.dejanews.com>

Hi!

I want to generate a a tabular report using SQL Plus 3.3. This report requires separate select statement for each column of report, on same table.

e.g.

U_Valus      Null_Values     Z_Values   >>>>>>>  Report Headings
  R1            R2              R3      >>>>>>>   Entries on the report

Here R1 is
"Select count(*)from table where table.column1 = "U";
Here R2 is
"Select count(*)from table where table.column1 is null;
Here R3 is
"Select count(*)from table where table.column1 = "Z";

Is it possible to do this type of reporting with SQL Plus?. If possible please write as how I can do this. Regards

Vishwas

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 01 1998 - 17:02:06 CDT