debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

void myfunc1()
{
    EXEC SQL create or replace
        function my_func (in_str IN varchar2)
        return date
        IS
        x date;
    BEGIN
    IF in_str IS NULL THEN
        x := NULL;
    ELSIF substr
        (in_str, 5,  1) = '-' THEN
                          x := to_date(in_str, 'YYYY-MM-DD HH24:MI:SS');
    END IF;
    return x;
    END my_func;
    END-EXEC;
}