Re: Nested select....

Viswanath Vijayaragavan wrote:

> Folks,Problem description : Out of a list of 20 tables T1... T20, I
> want to find out the count of rows in those Tables among the 20, which
> have a column called C1 (NUMBER (22)) and the value in C1 is 125. Any
> suggestionsVJ

Assuming you have been running statistics as your are supposed to for the optimizer ...

SELECT COUNT(*)
FROM all_tables
WHERE table_name IN (

   SELECT table_name
   FROM all_tab_columns
   WHERE column_name = 'whatever');

Daniel Morgan Received on Sat Aug 03 2002 - 18:14:42 CDT