webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
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