I have a view object which is something like select * from myview. This view has around a million records. I would like the the table to show the count of total amount of records in the view (so I need to get the total row count which would be about a million). But I want to limit this view to AT MOST only retrieve the first 1000 records. So I would like to retrieve at most 1000 records, but I want a count so the user knows there are about 1 million records. So if I ran the query it would say something like "showing 1000 records of 1,000,000" How can I do this? JDEV 12.1.2.