These are the keywords supported by Oracle and Microsoft® SQL Server™.
| Statement | Oracle | SQL Server |
|---|---|---|
| Declare variables | DECLARE | DECLARE |
| Statement block | BEGIN...END; | BEGIN...END |
| Conditional processing | IF...THEN, ELSIF...THEN, ELSE ENDIF; |
IF...[BEGIN...END] ELSE [BEGIN...END] CASE expression |
| Unconditional exit | RETURN | RETURN |
| Wait for a specified interval | N/A | WAITFOR |
| Loop control | WHILE...END LOOP; LABEL...GOTO LABEL; FOR...END LOOP; LOOP...END LOOP; |
WHILE... LABEL...GOTO LABEL |
| Program comments | /* ... */, -- | /* ... */, -- |
| Print output | DBMS_OUTPUT.PUT_LINE | |
| Raise program error | RAISE_APPLICATION_ERROR | RAISERROR |
| Execute program | EXECUTE | EXECUTE |
| Statement terminator | Semicolon (;) | N/A |