This discussion is archived
2 Replies Latest reply: Jan 24, 2013 8:18 PM by xarg-Xrc RSS

Need an answer

966679 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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');

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points