procedure to return muliple rows?

[slok]

I have a table as follows and need a procedure to return,
given a start date, end date, a count of all offences group by demerit code

==
Table stu_offences
OFF_DATETIME NOT NULL DATE
DEMERIT_CODE NOT NULL NUMBER(2)
MOD_DATETIME NOT NULL DATE
MOD_NAME NOT NULL CHAR(30)
stu_NO NOT NULL CHAR(10)
===


How can an procedure return multiple rows since there will
be different offences commited throughout the period?

 

[Dagon]

Use a REF CURSOR to return a result set.