I’m curious how I go about using multiple input parameters in Oracle PL/SQL.
For example, I would like to do something like this …
WHERE COUNTRY = ?
AND DEPARTMENT = ?
AND STATE = ?
Ultimately, I want the user prompted with custom prompt messages such as “Enter Country:”; “Enter Department:” ; “Enter State:”.
Any thoughts are welcomed!
Thanks and Regards,