Re: count for a newbie

From: Bryant Baecht <b_b_a_e_c_h_t_at_sun_flower.com>
Date: Mon, 18 Sep 2000 18:30:54 GMT
Message-ID: <sscnr7tim8p608@corp.supernews.com>

Here is an updated sql statement and the output:

 select segment_name,count(*) from sys.dba_segments where owner='F_SW' group  by segment_name

SEGMENT_NAME

---

-
  COUNT(*)

---

DA_ARCHIVEDATE
         1

DA_DELETEDATE
         1

DA_DOCNUMBER
         1

DC_DOCCLASSNAME
         1

DC_DOCCLASSNUMBER
         1

DI_DOCCLASSNUMBER
         1

DOCTABA
page^Cq

         1

8 rows selected.

Instead of the count always being equal to one ( because each table has only 1 entry in sys.dba_segments ), I want it to equal the number of entries in each respective table. Hopefully this is more descriptive. TIA

Bryant

In article <8q5ivs$stt$1_at_nnrp1.deja.com>, sanrenkur_at_my-deja.com wrote:
>Hi
>Try WHERE OWNER='TOM'
>Hth
>Sanrenkur
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Sep 18 2000 - 13:30:54 CDT