In our first example, we'll prompt the user for a supplier_id value. We'll demonstrate how to prompt for both a numeric as well as a text value below: Prompting for a numeric value Question: In SQLPlus, I'd like to set up a SQL statement so that the user is prompted for a portion of the query condition.Īnswer: You can use the & character to prompt a user for a value. Oracle / PLSQL: Prompt user for a parameter value in SQLPlus
0 Comments
Leave a Reply. |