1  create or replace procedure uza
  2  as
  3  cursor c1 is select regno,rpad(grn.name,40) as name,grn.faculty,round(cgpa,2) as cgpa,
  4  (dense_rank () over(partition by substr(regno,1,4) order by round(cgpa,2) desc)) as cgpa_rank,
  5  (count(regno) over(partition by substr(regno,1,4))) as batch_total
  6  from it,grn
  7  where it.regno=grn.rn
  8  and sc=1 and sy=2004
  9  and regno not like '9%';
 10  begin
 11  for x in c1 loop
 12  null;
 13  end loop;
 14* end;
SQL> /

Warning: Procedure created with compilation errors.

SQL> show err
Errors for PROCEDURE UZA:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/16     PLS-00103: Encountered the symbol "OVER" when expecting one of
         the following:
         . ( ) , * % & | = - + < / > at in mod not range rem => ..
         <an exponent (**)> <> or != or ~= >= <= <> and or like
         between is null is not || is dangling

SQL> 

SQL> select regno,rpad(grn.name,40) as name,grn.faculty,round(cgpa,2) as cgpa,
  2  dense_rank () over(partition by substr(regno,1,4) order by round(cgpa,2) desc) as cgpa_rank,
  3  count(regno) over(partition by substr(regno,1,4)) as batch_total
  4  from it,grn
  5  where it.regno=grn.rn
  6  and sc=1 and sy=2004
  7  and regno not like '9%'
  8  
SQL> /

MOD-Edit: Frank removed results on poster's request, since it showed personal data