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

, , , , , ,
1

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.

sql querie
sql querie916×585 77.2 KB

2

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

Regards.

3

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

4

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.