How to code for getting user input in PLSQL?

Question

I'm writing the following code in plsql for a user input but I don't know why its not working. I'll be thankful for a needed help in correcting it.

declare 
   -- Local variables here
   i number(10);
   id number(4);
begin
   i := 8||dbms_random.value(10000,99999);
   i := i * 10000 + &id;
   dbms_output.put_line(i);
end;

Answer 1

To ensure variable substitution is enabled in PL/SQL Developer, check for a blue ampersand button in the bottom left hand corner of the main window. When you hover the mouse cursor over the button, the pop up text "Variable substitution enabled" should display.

If the ampersand button is red, then variable substitution is disabled, and you can simply click the button to enable it.