![]() |
#1
|
|||
|
|||
![]()
IF THEN END IF;
IF THEN ELSE END IF; IF THEN ELSIF ELSE END IF;
__________________
Телеграм чат |
#2
|
|||
|
|||
![]() Код:
IF condition THEN ... sequence of executable statements ... END IF; Код:
IF salary > 40000 THEN give_bonus (employee_id,500); END IF;
__________________
Телеграм чат |
#3
|
|||
|
|||
![]() Код:
IF condition THEN ... TRUE sequence of executable statements ... ELSE ... FALSE/NULL sequence of executable statements ... END IF; Код:
IF salary <= 40000 THEN give_bonus (employee_id, 0); ELSE give_bonus (employee_id, 500); END IF; Код:
IF NVL(salary,0) <= 40000 THEN give_bonus (employee_id, 0); ELSE give_bonus (employee_id, 500); END IF;
__________________
Телеграм чат Последний раз редактировалось Marley; 19.10.2009 в 19:37. |
#4
|
|||
|
|||
![]() Код:
IF condition-1 THEN statements-1 ELSIF condition-N THEN statements-N [ELSE else_statements] END IF; Пример: Код:
IF salary BETWEEN 10000 AND 20000 THEN give_bonus(employee_id, 1500); ELSIF salary BETWEEN 20000 AND 40000 THEN give_bonus(employee_id, 1000); ELSIF salary > 40000 THEN give_bonus(employee_id, 500); ELSE give_bonus(employee_id, 0); END IF;
__________________
Телеграм чат |
#5
|
|||
|
|||
![]() Код:
CASE expression WHEN result1 THEN statements1 WHEN result2 THEN statements2 ... ELSE statements_else END CASE; Код:
CASE TRUE WHEN salary >= 10000 AND salary <=20000 THEN give_bonus(employee_id, 1500); WHEN salary > 20000 AND salary <= 40000 THEN give_bonus(employee_id, 1000); WHEN salary > 40000 THEN give_bonus(employee_id, 500); ELSE give_bonus(employee_id, 0); END CASE; Код:
DECLARE boolean_true BOOLEAN := TRUE; boolean_false BOOLEAN := FALSE; boolean_null BOOLEAN; FUNCTION boolean_to_varchar2 (flag IN BOOLEAN) RETURN VARCHAR2 IS BEGIN RETURN CASE flag WHEN TRUE THEN 'True' WHEN FALSE THEN 'False' ELSE 'NULL' END; END; BEGIN DBMS_OUTPUT.PUT_LINE(boolean_to_varchar2(boolean_true)); DBMS_OUTPUT.PUT_LINE(boolean_to_varchar2(boolean_false)); DBMS_OUTPUT.PUT_LINE(boolean_to_varchar2(boolean_null)); END;
__________________
Телеграм чат Последний раз редактировалось Marley; 19.10.2009 в 20:00. |