![]() ![]() When this script is executed, the following output is shown: PROMPT Type the department you are looking forĪCCEPT dept NUMBER PROMPT "Department Number: " The following example shows the prompt/accept sequence for a query. ![]() SQL*Plus has several commands that can be used to prompt the user for input, accept input from the user and store it in a variable, and then use that variable in a query.
0 Comments
Leave a Reply. |