webMethods

 View Only
Expand all | Collapse all

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

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

    Posted Sun September 25, 2022 08:48 AM

    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 queriehttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/61512fcf1a92f8533f160953aa7c75f2c426c4f6.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/61512fcf1a92f8533f160953aa7c75f2c426c4f6.png 2x" data-dominant-color="FAF9FB">
    sql querie916×585 77.2 KB


    #webMethods
    #Integration-Server-and-ESB
    #Oracle
    #Flow-and-Java-services
    #oracle-virtualbox
    #JDBC-Oracle-Reference-Cursor
    #SQL


  • 2.  RE: Could you please provide Stored procedure in oracle with Sorting columns and total pages request like this sql

    Posted Thu September 29, 2022 12:08 AM

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

    Regards.


    #SQL
    #Oracle
    #webMethods
    #oracle-virtualbox
    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #JDBC-Oracle-Reference-Cursor


  • 3.  RE: Could you please provide Stored procedure in oracle with Sorting columns and total pages request like this sql

    Posted Thu September 29, 2022 12:26 AM

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


    #Oracle
    #JDBC-Oracle-Reference-Cursor
    #oracle-virtualbox
    #SQL
    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services