SQL to find out user table which count > 0!

From: Yeung Man <yngm_at_chowsangsang.com>
Date: Fri, 15 Jan 1999 14:49:13 +0800
Message-ID: <77mois$ik1@news.hk.linkage.net>

Hi,

I want to find out all user tables in our application system with rowcount > 0. I know I can do with the analysis and the query the dict. But, can I just use SQL to find them out? TIA.

Best Regards,
Man

yngm_at_chowsangsang.com Received on Fri Jan 15 1999 - 00:49:13 CST

This message: [ Message body ]
Next message: Nicodemus Chan: "Re: Error using dynamic sql."
Previous message: mgogala_at_rocketmail.com: "Re: Oracle on NT versus UNIX???"
Next in thread: bob mourning: "Re: SQL to find out user table which count > 0!"
Reply: bob mourning: "Re: SQL to find out user table which count > 0!"
Reply: Reid Lai: "Re: SQL to find out user table which count > 0!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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