2 Replies Latest reply: Jan 24, 2013 10:18 PM by xarg-Xrc RSS

    Need an answer

    966679
      Hi all
      Please if any one know how to catch the selected value from drop down list in a form to the SQL query??
      wait to give me the appropriate answer

      Thanks a lot
        • 1. Re: Need an answer
          VC
          963676 wrote:
          Hi all
          Please if any one know how to catch the selected value from drop down list in a form to the SQL query??
          wait to give me the appropriate answer

          Thanks a lot
          Welcome to the forum !

          What apex version?

          Where is the SQL query? i.e. report,item etc

          If you are new to apex then please make sure you start with Oracle® Database 2 Day + Application Express Developer's Guide
          • 2. Re: Need an answer
            xarg-Xrc
            963676 wrote:
            Hi all
            Please if any one know how to catch the selected value from drop down list in a form to the SQL query??
            wait to give me the appropriate answer

            Thanks a lot
            Using Bind variable :P1_USERNAME or the v() function like: v('P1_USERNAME').
            select user_id, username from table_name where upper(username) = :P1_USERNAME;
            Or like:
            select user_id, username from table_name where upper(username) = v('P1_USERNAME');