Using PL/SQL with SQL Plus, how do I set up a loop, prompt the user for a value and then insert that info for as many times as the user wants to make records?
I have 3 fields. first name, last name, address
I set up the needed variables and the needed %rowtype variables.
I set up a loop to prompt the user.
the variables receive the input the first time successfully.
then after the last variable is input
I get an error: the Begin is unexpected and then it all fails for me.
Also, how do I set up a user input that tells my logic that the user is done.