May 2000
Intermediate to advanced
594 pages
11h 32m
English
Q: | |
3-16. | No. The IF statement is the only native PL/SQL conditional syntax. |
Q: | |
3-17. | There are two basic possibilities:
|
Q: | |
3-18. | Here is a function that implements an inline IF-ELSE statement, returning one of two strings: CREATE OR REPLACE FUNCTION ifelse
(bool_in IN BOOLEAN, tval_in IN VARCHAR2, fval_in IN VARCHAR2)
RETURN VARCHAR2
IS
BEGIN
IF bool_in
THEN
RETURN tval_in;
ELSE
RETURN fval_in;
END IF;
END;
/And here is an example of the ifelse function put to use: BEGIN
emp_status :=
ifelse (
hiredate > ADD_MONTHS (SYSDATE, -216),
'TOO YOUNG',
'OLD ENOUGH');This example is equivalent to this code: BEGIN
IF hiredate > ADD_MONTHS (SYSDATE, -216)
THEN
emp_status := 'TOO YOUNG';
ELSE
emp_status := 'OLD ENOUGH';
END IF;If you like this technique (it comes in especially handy when you want ... |