Oracle PL/SQL: FUNCTIONS: Sample functions - Functions to determine if a number is odd or even.

Quick Search:

Oracle PL/SQL: FUNCTIONS: Sample functions

Jump to:

Category: >> Oracle PL/SQL >> FUNCTIONS: Sample functions

<< last

next >>

Snippet Name: FUNCTIONS: Sample functions

Description: Functions to determine if a number is odd or even.

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 13th, 2009

--Function to determine if a number is even:
 
CREATE OR REPLACE FUNCTION is_even(num_in NUMBER) RETURN BOOLEAN IS
BEGIN
  IF MOD(num_in, 2) = 0 THEN
    RETURN TRUE;
  END IF; 
EXCEPTION
  WHEN OTHERS THEN
    RETURN FALSE;
END is_even;
/ 
 
 
 
 
-- Function to determine if a number is odd: 
 
CREATE OR REPLACE FUNCTION is_odd(num_in NUMBER) RETURN BOOLEAN IS
BEGIN
  RETURN MOD(num_in, 2) = 1;
EXCEPTION
  WHEN OTHERS THEN
    RETURN FALSE;
END is_odd;
/