Prepares an SQL statement dynamically generated by a program for
execution, and assigns a name to that statement.
Dynamic SQL lets programs accept or generate SQL statements
at run time, in contrast to SQL module language procedures.
Unlike precompiled SQL or SQL module language statements, such
dynamically executed SQL statements are not necessarily part of a
program's source code, but can be generated while the program is
running. Dynamic SQL is useful when you cannot predict the type
of SQL statement your program will need to process.
The PREPARE . . . INTO statement stores in the SQLDA the number
and data types of any select list items of a prepared statement.
The SQLDA provides information about dynamic SQL statements to
the program and information about memory allocated by the program
to SQL.
The Oracle Rdb SQL Reference Manual describes in more detail
the specific fields of the SQLDA, and how programs use it to
communicate about select list items in prepared statements.
Additional Information:
explode
extract