Hi, I am trying to count the number of rows each view has in an oracle database. There are over 100 views. I want it to display the view name and the number of rows. I tried SELECT VIEW_NAME, COUNT(*) FROM ALL_VIEWS But this doesn't work. I tried a similar query using a group by of view_name and max(rownum) but this too didn't work. The SQL I'm writing is generating the count of view_names or max(rownum)'s assigned to view_names. I need the count of rows for each individual view_name. Is there a simple way to do this? Thanks, Rob.