Searching through a copy (of a draft) of the 2011 SQL Standard, there is no mention at all of a FORALL
keyword.
Neither in the main document ("Part 2: Foundation (SQL/Foundation)") which describes the core SQL language nor in the extensions document ("Part 4: Persistent Stored Modules (SQL/PSM)") which describes persistent routines and server modules. There are several control and repeat structures and keywords (DO
, ITERATE
, FOR
, LOOP
, WHILE
, REPEAT
) but not FORALL
.
Postgres docs also have an extensive list of SQL Key Words (taken from the 92, 2008 and 2011 versions of the standard). No mention of FORALL
there either.
FORALL
seems to be a keyword only in Oracle's procedural language extension to SQL.
FORALL
seems to be a part of PL/SQL, which is Oracle's procedural language extension to SQL.