Database servers specify rules for where host variables can appear in a query. Refer to documentation for your database server for these rules.
Host variables must have a specific data type. A value that you provide for a host variable must conform to that variable's data type.
A procedure is a set of commands that enable you to run queries, print reports, import and export data, and perform other functions with a single command.
It was designed so that it would be truly easy to use for both professionals and casual users and was designed to work in several diverse application areas -- such as personal programming, command processing, application macro processing and application prototyping -- where different languages are typically used. It is, however, designed to be platform-independent.
When a static query is executed, the database server uses the SQL text bound into the package, rather than the SQL text currently appearing in the query window. Static queries are more resource efficient than dynamic queries, but static queries cannot be edited.
Substitution variables must begin with an ampersand (&) and can contain up to 18 characters, which can be alphabetic, numeric or one of the following characters: [ ! $ ~ { } ? @ # % \ _.