For the PL/SQL syntax, see "SELECT INTO Statement". ... three PL/SQL variables and uses them in the static SQL statements INSERT , UPDATE , DELETE .
docs.oracle.com