I am using the bind function to input the date and state. What should I do to get a predefined list to input my state IDs. For example, I may want to create the report for below states. I may select one or some times more. How do I pick my states as I wish to run the code.
Tool : Toad Data point 3.2/Oracle
List of States : OR, WA, ID,CA, UT
Select * from mytable WHERE Calendar_date BETWEEN :Start_date AND :End_date AND State_ID in :Enter_State_ID