Example 1: Specifying Predicates with Variable References

    SQL> CREATE TABLE T (C INT);
    SQL> BEGIN
    cont> DECLARE :V INTEGER = 10;
    cont> DECLARE :X INTEGER = 0;
    cont> CASE
    cont>   WHEN :V = 1 THEN INSERT INTO T(C) VALUES (:X + 1);
    cont>   WHEN :V = 2 THEN INSERT INTO T(C) VALUES (:X + 2);
    cont>   WHEN :V > 3 THEN INSERT INTO T(C) VALUES (:X);
    cont>   ELSE INSERT INTO T(C) VALUES (-1);
    cont> END CASE;
    cont> END;