EXECUTE ... END-EXEC

EXECUTE ... END-EXEC
Prev	Up	33.14. Embedded SQL Commands	Home	Next

EXECUTE ... END-EXEC — execute an anonymous block

Synopsis

EXECUTE
anonymous block
END-EXEC;

EXECUTE ... END-EXEC is used to execute an anonymous block in LightDB.

Here is an example that executes an anonymous block using EXECUTE:

EXEC SQL EXECUTE
    begin
        select val into :val from test where id = :id;
    end;
END-EXEC;

There is no anonymous block the SQL standard, and EXECUTE ... END-EXEC is not specified in the SQL standard. This is for oracle compatibility.