Could you please provide Stored procedure in oracle with Sorting columns and total pages request like this sql

I want to create stored procedure in oracle with Sorting columns and total pages request .can u plz provide the query of oracle .
i know only sql i tried in Microsoft sql server mgmt studio.

Hi,
Can you please let me know which Software AG products you are trying this with?

Regards.

Software AG 10.1 and 10.11
DB: Microsoft SQL server and Management Studio,
Oracle SQL Developer