While Loop and If/Else in PL/SQL

Question

I am trying to write a procedure that will produce the following output

exec WinOrLose(4)

Welcome to the Win or Lose Game. Your number is 4. 

You win.
You lose.
You win.
You lose.

==> You lose!

So far I have this:

CREATE or REPLACE Procedure WinOrLose (
  p_choice number ) AS

  v_answer number;

DECLARE
  v_answer := p_choice

BEGIN
  dbms_output.put_line ('Welcome to the Win or Lose Game. Your number is ' || 
  v_answer);

  FOR v_answer in 1..10 
    IF MOD(v_answer, 2) = 0 THEN -- v_answer is even
          dbms_output.put_line (You lose)

END;
/

I'm unsure of where to go from there. My thought process (psuedocode) is this:

SET v_answer := 1
   While Loop (outside)
     MOD(v_answer,2) = 0 then dbms.output (YOU LOSE)
   ELSE
     dbms.output (YOU WIN)
   end if;
     v_answer := p_choice

What are the rules? Looking at the code and pseudo code nothing makes any sense. — Goran Stefanović
– Goran Stefanović, Commented Oct 10, 2017 at 13:46

Radim Bača · Accepted Answer · 2017-10-11 05:22:35Z

2

CREATE or REPLACE Procedure WinOrLose (
  p_choice number ) AS
BEGIN
  dbms_output.put_line ('Welcome to the Win or Lose Game. Your number is ' || 
  p_choice);

  FOR v_counter in 1..p_choice LOOP
    IF (MOD(v_counter, 2) = 0) 
    THEN
          dbms_output.put_line ('You win');
    ELSE
          dbms_output.put_line ('You lose');
    END IF;
  END LOOP;

  IF (MOD(p_choice , 2) = 0) 
  THEN
    dbms_output.put_line ('==> You win!');
  ELSE
    dbms_output.put_line ('==> You lose!');
  END IF;
END;
/

edited Oct 11, 2017 at 5:22

answered Oct 10, 2017 at 8:33

Radim Bača

10.7k1 gold badge21 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Lizzie Over a year ago

Thank you! Last question, how would I output "==> You lose!" or "==> You win!" at the end?

Radim Bača Over a year ago

@Lizzie You are welcome! I have edited it, let me know if it is working. Best.

Lizzie Over a year ago

Thank you so much!

Collectives™ on Stack Overflow

While Loop and If/Else in PL/SQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related