Click here to Skip to main content
14,979,508 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
DECLARE
localvar char;
BEGIN
localvar := &ENUMBER;
IF localvar ='A' then
dbms_output.put_line('Please proceed to Level1');
ELSIF localvar='B' or localvar='C' then
dbms_output.put_line('Please proceed to Level2');
ELSIF localvar='D' then
dbms_output.put_line('Please proceed to Level3');
ELSE
dbms_output.put_line('Invalid Entry');
END IF;
END;


i want to prompt the user for input using substitution variable but its not working for me any help would be appreciated
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900