1 2 Previous Next 20 Replies Latest reply on Jun 15, 2018 3:34 PM by Mike Kutz

    Prompt order for multiple bind variables

    Notorious

      Hello.

      I am fairly new to writing sql statements in Oracle, but like to experiment and welcome challenges.  I have a sql statement that uses multiple bind variables to prompt the user for input in determining what to query for.  The sql works great except for the order in which the bind variables appear in the user prompt window.  Is there any way to control the order in which they appear?  Or, is it strictly random?  The variables would make more sense if I could put them in a particular order.

      Any suggestions/input would be greatly appreciated!

      N.

        1 2 Previous Next