December 2002
Intermediate to advanced
928 pages
85h 29m
English
EXECUTE IMMEDIATEsql_statement[INTO {variable[,variable...] |record|object_variable}] [USING [IN | OUT | IN OUT]bind_argument[,[IN | OUT | IN OUT]bind_argument...] ] [{RETURNING | RETURN} INTObind_argument[,bind_argument]...];
Parses and executes a SQL statement in a single step. It can be used for any SQL statement except a multirow query. With Oracle9i, the EXECUTE IMMEDIATE statement can be used for bulk fetches and bulk INSERTs or UPDATEs, even if they encounter errors in the bulk processing.
To use dynamic SQL with queries that return multiple rows, use a CURSOR variable, described in the next section.
The EXECUTE IMMEDIATE statement requires a terminating semicolon, but the sql_statement must not have a trailing semicolon.
The keywords are the same as for standard SQL and explicit cursors.