with vtab as (
    select
        t.*,
        count(*) over() as cnt,
        row_number() over(order by col1) as rn
    from table_name t
    where ...
)
select col1, col2, col3, ..., cnt
from vtab
where rn <= 10

select rownum as rn, t.*
from
(
  select p.*, t.qty
  from
  (
    select count(*) as qty
    from table_name
    where ...
  ) t
  cross join table_name p
  where ...
) t
where (rownum <= 10)