I have the following problem - how to read user input from the command line? Can this be done using only PL/SQL and SQL?
Here is an example. First I want to read the "user choice", and if it is 1, read the value for "a", if it is 2 - read the value for "b". But when I execute the code below (from sql window), it prompts me to enter the "user choice" and after that, regardless of my input prompts me to enter BOTH "a" AND "b". After that, it executes only the statements (not shown in the code) for corresponding "user_choice". Someone told me that "the precompiler looks for the & symbol when parsing the code and does the prompts". Is there a way around it?
VARIABLE user_cho NUMBER
ACCEPT user_cho PROMPT 'Enter your choice: '
user_choice NUMBER := &user_cho;
a NUMBER := 0;
b NUMBER := 0;
IF(user_choice = 1)
a := &a;
ELSIF(user_choice = 2)
b := &b;