Chapter 1 Programming Concepts

1)Create the following structure: Based on the value of a number, determine if it is even or odd. Hint: Before you decide how to define even and odd numbers, you should decide what structure must be used to achieve the desired results.
A1: Answer: Your answer should look similar to the following:
IF MOD(NUMBER, 2) = 0 
   DISPLAY 'THIS NUMBER IS EVEN' 
IF MOD(NUMBER, 2) != 0 
   DISPLAY 'THIS NUMBER IS ODD' 

In this example, you are using the selection structure because a decision whether a number is even or odd must be made. This decision can be made with the help of the built-in function MOD. This function returns the remainder of the NUMBER divided by 2. If a number is divisible by 2 (in other words, there is no remainder), ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.